- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 25, 2025 04:47 AM
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 25, 2025 05:27 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 25, 2025 05:27 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 25, 2025 05:29 AM
Also, you might want to check out Record Coloring in Airtable!
Mike, Consultant @ Automatic Nation
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 25, 2025 05:55 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 25, 2025 05:57 AM
Do not worry! Happy to help. Let me know if anything else comes up 🙂
