This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hey everyone,
I have a Deadline column (date) and a “Urgency” column in a sheet. I want any row/item due in less than or equal to two days to be marked in other column as Urgent, and I want anything longer than that to be marked as Not Urgent.
I’m gu...
Thanks so much!! I just had to tweak a few things and it worked perfectly for me:
IF(DATETIME_DIFF({Due},TODAY(),‘days’)<=2, “Urgent”,“Not Urgent”)
I appreciate it so much!
