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


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! :smiley:

Thank you!


Hi @Belen_Bueso_Rios,

I think this formula might help you

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


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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.