What is wrong with this formula?
Hi,
Could one of you please tell me what is wrong with this formula:
=IF([% Complete]@row = 100%, "Blue", IF([End Date]@row <= TODAY, "Red", IF([End Date]@row < TODAY(5), "Yellow", "Green")))
I keep getting an #UNPARSEABLE error.
Best Answer
-
You need open and close parenthesis after the first TODAY function.
=IF([% Complete]@row = 100%, "Blue", IF([End Date]@row <= TODAY(), "Red", IF([End Date]@row < TODAY(5), "Yellow", "Green")))
If your [% Complete] column is actually set up to be a percentage, then you will also want to change your criteria there. Percentages in Smartsheet are calculates as a percentage of 1.
So 100% = 1, 50% = .5, etc., etc.
=IF([% Complete]@row = 1, "Blue", IF([End Date]@row <= TODAY(), "Red", IF([End Date]@row < TODAY(5), "Yellow", "Green")))
Answers
-
You need open and close parenthesis after the first TODAY function.
=IF([% Complete]@row = 100%, "Blue", IF([End Date]@row <= TODAY(), "Red", IF([End Date]@row < TODAY(5), "Yellow", "Green")))
If your [% Complete] column is actually set up to be a percentage, then you will also want to change your criteria there. Percentages in Smartsheet are calculates as a percentage of 1.
So 100% = 1, 50% = .5, etc., etc.
=IF([% Complete]@row = 1, "Blue", IF([End Date]@row <= TODAY(), "Red", IF([End Date]@row < TODAY(5), "Yellow", "Green")))
-
Thank you Paul. You addressed both of my errors. Super helpful. Worked as soon as I fixed these two issues.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 68K Get Help
- 474 Global Discussions
- 209 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 85 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!