Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Using Date Field to Set Urgency

Topic Labels: Formulas
Solved
Jump to Solution
343 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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!