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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!