Skip to main content
Solved

Highlight a Line With Overdue Date

SparKey

Hi There, 

I know I should already know this but I always get nervous when dates are involved. 

I want to be able to highlight either a field or a row when a task in the row passes the deadline. I don't need to know any other information like how many days over it is, I just want it to be highlighted to bring attention to it. 

I have a [Date Due] column and a [Status] column. The idea is that the status column would be set to "On Time" or "Overdue" to allow filtering

Can anyone tell me what formula I can use to trigger the change in the status column?

Thank you for your time. 

S

Best answer by Mike_AutomaticN

Hey @SparKey!

If you are only interested on those two outputs, you could have a unique formula field, which you can further format the output to be single select.


Formula should be:

IF({Date Due} < TODAY(), "Overdue", "On Time")

 Some additional tweaks could be applied if you'd like to track complete tasks as well.

If in need of further help, please feel free to schedule a call! I'd be happy to help out.

Mike, Consultant @ Automatic Nation

View original
Did this topic help you find an answer to your question?

4 replies

Mike_AutomaticN

Hey @SparKey!

If you are only interested on those two outputs, you could have a unique formula field, which you can further format the output to be single select.


Formula should be:

IF({Date Due} < TODAY(), "Overdue", "On Time")

 Some additional tweaks could be applied if you'd like to track complete tasks as well.

If in need of further help, please feel free to schedule a call! I'd be happy to help out.

Mike, Consultant @ Automatic Nation

SparKey
1 person likes this
  • SparKey
    SparKey
Mike_AutomaticN

Also, you might want to check out Record Coloring in Airtable!

Mike, Consultant @ Automatic Nation

SparKey
  • SparKey
  • Author
  • Inspiring
  • 7 replies
  • February 25, 2025

Spot on @Mike_AutomaticN . Like I said, I should already know this but I just couldn't think the logic through and don't have anyone else to turn to. 

Mike_AutomaticN
SparKey wrote:

Spot on @Mike_AutomaticN . Like I said, I should already know this but I just couldn't think the logic through and don't have anyone else to turn to. 


Do not worry! Happy to help. Let me know if anything else comes up 🙂 

Reply


Most helpful members this week

Terms & Conditions