Help

Formula for when Deadline is overdue, excluding certain statuses

Topic Labels: Formulas
2502 13
cancel
Showing results for 
Search instead for 
Did you mean: 
Andy_Abelow
4 - Data Explorer
4 - Data Explorer

I’ve looked all over for this, and there are formulas that get close, but nothing that quite gets what I want.

If the date is equal to or past the date under “Deadline”, autofill the formula cell with “OVERDUE”, unless the Status column (single select) is tagged “Complete”, in which case it should say “Done” no matter what (before, on, or after deadline)

Else-wise, the formula cell should be blank.

13 Replies 13
augmented
10 - Mercury
10 - Mercury

Try something like this (might need a tweak)…

IF({Status}=“Complete”,“Done”,IF(IS_AFTER(TODAY(),{Deadline}),“OVERDUE”))

Andy_Abelow
4 - Data Explorer
4 - Data Explorer

It says invalid formula.

Can you copy/paste the formula as you have it? Did you need to change either of the field names?

Andy_Abelow
4 - Data Explorer
4 - Data Explorer

I pasted exactly what you suggested and didn’t need to change any field names. The columns are labeled Deadline and Status on my base.

augmented
10 - Mercury
10 - Mercury

Well, I wanted to see your formula because, sometimes when you copy/paste, the double quotes get turned into the wrong type of quotes.

I’ll bet you $1 that if you manually retype the double quotes, the formula will work well.

Good luck!!

Andy_Abelow
4 - Data Explorer
4 - Data Explorer

Maybe you owe me $1?

IF({Status}=“Complete”,“Done”,IF(IS_AFTER(TODAY(),{Deadline}),“OVERDUE”))

Screen Shot 2021-02-16 at 11.33.58 AM Screen Shot 2021-02-16 at 11.34.48 AM

Andy_Abelow
4 - Data Explorer
4 - Data Explorer

YOU WERE RIGHT! It was a difference of slanted quotes vs regular quotes.

Looking good! How would I add in for multiple Statuses, like if i wanted it to ignore “Complete” and “Archived”

When you say “ignore”, do you mean how would you remove them from view? If that’s the case, you would use the filter capability of the view.

image