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!!!
Best answer by Ilan_Ben_Yaakov
You should use the DATETIME_DIFF function, it should look something like this
`
IF(DATETIME_DIFF(Due,TODAY())>2,“Urgent”,“Not Urgent”)
`
+7You 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
