Find and Replace single row which changes

Question

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 Answer

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