Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Highlight a Line With Overdue Date

Solved
Jump to Solution
117 4
cancel
Showing results for 
Search instead for 
Did you mean: 
SparKey
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
Mike_AutomaticN
10 - Mercury
10 - Mercury

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.

Mike_AutomaticN_0-1740489992218.png


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

See Solution in Thread

4 Replies 4
Mike_AutomaticN
10 - Mercury
10 - Mercury

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.

Mike_AutomaticN_0-1740489992218.png


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

Mike_AutomaticN
10 - Mercury
10 - Mercury

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

Mike, Consultant @ Automatic Nation

SparKey
5 - Automation Enthusiast
5 - Automation Enthusiast

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 🙂