Help

Formula to flag if a record has been edited after a certain date

Topic Labels: Formulas
Solved
Jump to Solution
1035 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Belen_Bueso_Rio
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello!

I’m trying to write a formula to get a bell emoji if a record has been modified after the date we close our quarterly reporting by. I have the “last modified” field and the “report closure” dates to compare, but I am struggling to write the “IF” formula in the right way.

Any help would be massively appreciated! :grinning_face_with_big_eyes:

Thank you!

Belén

1 Solution

Accepted Solutions
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Belen_Bueso_Rios,

I think this formula might help you

IF(DATETIME_DIFF({Last Modified},{Report Date},'days')>=0,"🔔")

BR,
Mo

See Solution in Thread

2 Replies 2
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Belen_Bueso_Rios,

I think this formula might help you

IF(DATETIME_DIFF({Last Modified},{Report Date},'days')>=0,"🔔")

BR,
Mo

Belen_Bueso_Rio
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you so, so much! Muchas gracias :slightly_smiling_face: