Formula not working (UNPARSEABLE)
I have the following formula that is not working.
=IF(AND([TOTAL %]6 > 0, [TOTAL %]6 <= 0.1), "YELLOW" , IF(AND([TOTAL %]6 <= 0, [TOTAL%]6 > -0.1), "GREEN", IF([TOTAL %]6 <- 0.1, "PURPLE", IF([TOTAL %]6 > 0.1,"RED"
The return I get is (UNPARSEABLE)
Please advise if you can find the error in my formula.
Regards,
Derrick Smith
Best Answer
-
Hi @1996mustang ,
I found a typo. Missing a space. Try this:
=IF([TOTAL %]6 > 0.1,"RED", IF(AND([TOTAL %]6 > 0, [TOTAL %]6 <= 0.1), "YELLOW" , IF(AND([TOTAL %]6 <= 0, [TOTAL %]6 > -0.1), "GREEN", IF([TOTAL %]6 <= -0.1, "PURPLE" ))))
If you're evaluating multiple rows you should change [Total %]6 to [Total %]@row so the San formula can be copied down or made into a column formula.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @1996mustang ,
Try:
=IF([TOTAL %]6 > 0.1,"RED", IF(AND([TOTAL %]6 > 0, [TOTAL %]6 <= 0.1), "YELLOW" , IF(AND([TOTAL %]6 <= 0, [TOTAL%]6 > -0.1), "GREEN", IF([TOTAL %]6 <= -0.1, "PURPLE" ))))
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Mark,
Still getting #UNPARSEABLE
thanks
ds
-
Hi @1996mustang ,
I found a typo. Missing a space. Try this:
=IF([TOTAL %]6 > 0.1,"RED", IF(AND([TOTAL %]6 > 0, [TOTAL %]6 <= 0.1), "YELLOW" , IF(AND([TOTAL %]6 <= 0, [TOTAL %]6 > -0.1), "GREEN", IF([TOTAL %]6 <= -0.1, "PURPLE" ))))
If you're evaluating multiple rows you should change [Total %]6 to [Total %]@row so the San formula can be copied down or made into a column formula.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
That worked! Thank you for your help!
Regards,
ds
-
Happy to help. Please mark my answer as accepted to close the discussion. Thank you for using the Community.
Be Well, Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Mark was a great help!😊
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 303 Events
- 34 Webinars
- 7.3K Forum Archives