Harvey Ball formula based on dates
Hello,
I have Revision Due column and I would like to automate the Harvey Ball formula that if the Revision Due date is older than today's date the ball would be Red.
If the Revision Due date is within 60 days of today the ball would be yellow.
If the Revision Due date is days the ball would be green.
I've tried the formula below but I keep getting the #unparseable error.
=IF([Revision due] >= TODAY(), "Red", IF([Revision Date] <= TODAY([+60]), "Yellow", "Green"))
Any help is appreciated as I learn my way through Smart Sheet. I know there are plenty of questions similar but when I've tried to edit the existing solutions to match my sheet I'm having a hard time. Thanks!
Best Answer
-
Close. Try this (updates in bold):
=IF([Revision Due]@row < TODAY(), "Red", IF([Revision Due]@row <= TODAY(60), "Yellow", "Green"))
Answers
-
Close. Try this (updates in bold):
=IF([Revision Due]@row < TODAY(), "Red", IF([Revision Due]@row <= TODAY(60), "Yellow", "Green"))
-
Thank you so much Paul! This worked like a dream.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 412 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 140 Just for fun
- 57 Community Job Board
- 461 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
