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
Best answer by Mohamed_Swella1
Hi @Belen_Bueso_Rios,
I think this formula might help you
IF(DATETIME_DIFF({Last Modified},{Report Date},'days')>=0,"🔔")
BR,
Mo
+17Hi @Belen_Bueso_Rios,
I think this formula might help you
IF(DATETIME_DIFF({Last Modified},{Report Date},'days')>=0,"🔔")
BR,
Mo
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.