Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Apr 07, 2020 05:43 AM
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
Solved! Go to Solution.
Apr 07, 2020 09:51 PM
I think this formula might help you
IF(DATETIME_DIFF({Last Modified},{Report Date},'days')>=0,"🔔")
BR,
Mo
Apr 07, 2020 09:51 PM
I think this formula might help you
IF(DATETIME_DIFF({Last Modified},{Report Date},'days')>=0,"🔔")
BR,
Mo
Apr 08, 2020 11:04 AM
Thank you so, so much! Muchas gracias :slightly_smiling_face: