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
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
