Help

Using Date Field to Set Urgency

Topic Labels: Formulas
Solved
Jump to Solution
767 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Steven_Piasecki
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
Ilan_Ben_Yaakov
6 - Interface Innovator
6 - Interface Innovator

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

`

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

`

See Solution in Thread

2 Replies 2
Ilan_Ben_Yaakov
6 - Interface Innovator
6 - Interface Innovator

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!