Skip to main content

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 guessing there’s a good formula for this, but I’ve poked around for a bit and haven’t been able to find one/do it myself.


Any help is much appreciated!!!

You should use the DATETIME_DIFF function, it should look something like this


`



IF(DATETIME_DIFF(Due,TODAY())>2,“Urgent”,“Not Urgent”)



`

You should use the DATETIME_DIFF function, it should look something like this


`



IF(DATETIME_DIFF(Due,TODAY())>2,“Urgent”,“Not Urgent”)



`


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!

Reply


Terms & Conditions