Find and Replace single row which changes

[Ariz]

Hi all 

Hope you are well,just wondering how can I find and replace single row which gets updated daily please ? 

Please see an attached example  where single row for January (month changes) in COB Dates field needs to be updated with new value under field COB Dates2. Any thoughts please ?

Thanks in advance

Ariz

 

[ShankerV · Accepted solution]

Hi @Ariz 

Based on the input shared, please make use of the Formula tool.

Select the column name as "COB Dates" in the drop down of the Filter tool

IF [Month] = "January"

THEN [COB Dates2]

ELSE [COB Dates]

ENDIF

[Ariz]

Thanks Shanker! It worked