Want to have status symbols change based on the value of a cell.

Greetings,

I have two columns, one to indicate Project Progress, and one to display the progress as a symbol. I want to create a formula to connect the Project Progress dropdown options with each of the Harvey ball symbols and came up with the formula below. Each individual formula works, but when combining the formulas, it shows an #UNPARSABLE

=IF([Project Progress]@row= "0-25% - Not Started/very little progress", "Empty")

=IF([Project Progress]@row= "25-50% - Some progress made", "Quarter")

=IF([Project Progress]@row= "51-75% - Significant progress made", "Half")

=IF([Project Progress]@row= "0-25% - 76-99% - Nearly complete/submitted to communications", "Three Quarter")

=IF([Project Progress]@row= "100% - Published", "Full")

The combined formula is:

=IF([Project Progress]@row= "0-25% - Not Started/very little progress", "Empty"), IF([Project Progress]@row= "25-50% - Some progress made", "Quarter"), IF([Project Progress]@row= "51-75% - Significant progress made", "Half"), IF([Project Progress]@row= "0-25% - 76-99% - Nearly complete/submitted to communications", "Three Quarter"), IF([Project Progress]@row= "100% - Published", "Full")

Find more posts tagged with

Accepted answers

Melissa Yamada

Hello @leannanemeth

You're having the error because you got excess closing parenthesis.

To fix your formula, try this:

=IF([Project Progress]@row= "0-25% - Not Started/very little progress", "Empty", IF([Project Progress]@row= "25-50% - Some progress made", "Quarter", IF([Project Progress]@row= "51-75% - Significant progress made", "Half", IF([Project Progress]@row= "0-25% - 76-99% - Nearly complete/submitted to communications", "Three Quarter", IF([Project Progress]@row= "100% - Published", "Full")))))

All comments

leannanemeth

Just noting that I did remove the "Restrict to symbol values only" from the project status column!

Melissa Yamada

Hello @leannanemeth

You're having the error because you got excess closing parenthesis.

To fix your formula, try this:

leannanemeth

Thank you so much! I got it to work.

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.