Red, Yellow, Green, Gray automation formula help needed
I have a sheet with a drop down column, then a symbol column. I am trying to automate the color of the symbol in the symbol column based on the drop down choice selected in the drop down column.
This is the formula I'm using, but I keep getting "unparsable" back:
=IF([Estimated Days to Close]@row = "0 - 90 Days"; "Green"; IF([Estimated Days to Close]@row = "91 - 120 Days"; "Yellow"; IF([Estimated Days to Close]@row = "121 Days or greater"; "Red"))))
NOTE: I haven't added it yet, but the final color will be gray if none of the other conditions have been met.
Any help would be appreciated. Thank you!
Comments
-
It is only an extra parenthesis at the end...
=IF([Estimated Days to Close]@row = "0 - 90 Days"; "Green"; IF([Estimated Days to Close]@row = "91 - 120 Days"; "Yellow"; IF([Estimated Days to Close]@row = "121 Days or greater"; "Red")))
Here's a tip (two actually):
- If all you have are nested IF statements, then you can count your IF's and that should be the number of closing parenthesis on the end.
- If all that is left is closing parenthesis at the end of the formula, you can actually exit the cell and Smartsheet will automatically add enough closing parenthesis to close everything out.
Adding in Grey:
=IF([Estimated Days to Close]@row = "0 - 90 Days"; "Green"; IF([Estimated Days to Close]@row = "91 - 120 Days"; "Yellow"; IF([Estimated Days to Close]@row = "121 Days or greater"; "Red"; "Grey")))
-
Hi Paul, I just tried it and I'm still getting unparsable. I'm not sure what I'm doing wrong still?
Here is a published test sheet as an illustration: https://app.smartsheet.com/b/publish?EQBCT=9d9f08f7fd914a00af080ec561d2f913
-
The syntax looks correct. Depending on your region... You may try swapping the semicolons out for commas.
-
That did it! I wasn't aware there was a regional difference, thank you so much!
-
Happy to help! 👍️
Please don't forget to mark the most appropriate response(s) as being "helpful" so that others with a similar issue know a solution can be found here.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives