Using Symbols to mark Past Due
I am trying to Mark the Due for Maintenance Box with the Red Explanation (High Priority) if the due date is before today.
Here is the formula I tried but it's not working:
=IF([Next Maintenance Due]@row < TODAY(), "High")
Answers
-
What result are you getting?
Your formula is working fine for me. The only thing I can think of is if your "Next Maintenance Due" column is not set to "Date" as the type, then the check vs. today's date isn't carried out and you get #INVALID OPERATION instead, as you can see below:
The first row has your formula in it, the second one is comparing to the same date, but as a text field instead of date.
-
Are you getting an error message, or is the ! just not appearing when it should?
I'm assuming that the Next Maintenance Due column is indeed a date-type column with a real date-type value?
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!