#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.

Find more posts tagged with

Accepted answers

Mary_A

@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")

All comments

Mary_A

@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")

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.