Unparseable Error
Hi,
I would like to add a health status formula but i am receiving an error.
=IF(Status@row = "Not started", "Blue", IF(Status@row="In Progress", "Yellow", IF(AND(TODAY() > [end date]@row, Status@row="In Progress"), "Red", IF(Status@row="Complete", "Green"))))
Any help would be greatly appreciated.
Best Answer
-
Yes and i realized i was missing some additional parenthesis.
Correct Formula
=IFERROR(IF([% Complete]@row = 1, "Blue", IF((1 - (NETWORKDAYS(TODAY(), [End Date]@row) / Duration@row)) - [% Complete]@row >= 0.2, "Red", IF((1 - (NETWORKDAYS(TODAY(), [End Date]@row) / Duration@row)) - [% Complete]@row >= 0.1, "Yellow", "Green"))), "")
Thank you so much!
Answers
-
Are you able to provide a screenshot of the formula in the sheet similar to the screenshot below?
-
I updated the formula but i am still receiving Unparseable error.
-
It looks like you have some misplaced parenthesis in this new formula. Try removing the opening parenthesis before the first NETWORKDAYS function.
-
Yes and i realized i was missing some additional parenthesis.
Correct Formula
=IFERROR(IF([% Complete]@row = 1, "Blue", IF((1 - (NETWORKDAYS(TODAY(), [End Date]@row) / Duration@row)) - [% Complete]@row >= 0.2, "Red", IF((1 - (NETWORKDAYS(TODAY(), [End Date]@row) / Duration@row)) - [% Complete]@row >= 0.1, "Yellow", "Green"))), "")
Thank you so much!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!