Using Date Field to Set Urgency

[Steven_Piasecki]

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

[Ilan_Ben_Yaakov · Accepted solution]

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

`

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

`

[Steven_Piasecki]

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!