#UNPARSEABLE error on trying to return a "red", yellow", "green" dot symbol
I'm trying to get Smartsheet to return a "red", yellow", "green" dot symbol to track the health of my data.
Right now, my formula looks like this: =IF(COUNTBLANK([New Project #]1:VOLUMES1) = 0,"GREEN",IF(COUNTBLANK([New Project #]1:VOLUMES1)<7,"YELLOW","RED"),"RED")
where: [New Project #]1:VOLUMES1 contains 15 cells in a row to evaluate data from.
I want the formula to return a green dot symbol if 0 of the 15 cells are blank, a yellow dot symbol if less than 7 cells are blank, and a red dot symbol if neither one of those two options are true.
Right now, I'm getting an #UNPARSEABLE error. Please help if you can.
Best Answer
-
@Sarah Watts I cannot find
COUNTBLANK
in the list of available functions. So, likely that is what is causing the parseable error.I think you want simply
COUNT
. For example:=IF(COUNT([Tractor Trailer]2:[Percent Customer]2) > 0, "NOT EMPTY", "EMPTY")
Answers
-
@Sarah Watts I cannot find
COUNTBLANK
in the list of available functions. So, likely that is what is causing the parseable error.I think you want simply
COUNT
. For example:=IF(COUNT([Tractor Trailer]2:[Percent Customer]2) > 0, "NOT EMPTY", "EMPTY")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!