Formula to Change Symbol Color Based on % Complete

Hi all,

I am trying to have the symbol color change based on the % Complete on a task. I have gotten it to work for 3 colors (Red/Yellow/Green) in another sheet, but now I am trying to do the same with 4 colors, including Blue. I am looking to have symbol turn Green when % Complete is at 100%, Yellow when % Complete is greater than Zero, Blue when % Complete is greater than 50%,, and Red when % Complete is Zero. I thought I had the formula correct, but when I changed a % Complete to 60%, the symbol still remains Yellow.

Here's the formula I have. Any help would be appreciated!

=IF([% Complete]@row = 1, "Blue", IF([% Complete]@row > 0, "Yellow", IF([% Complete]@row > 0.5, "Green", "Red")))

Find more posts tagged with

Formulas

symbols

if formula

Accepted answers

Paul Newcome

Give this a try:

=IF([% Complete]@row = 1, "Blue", IF([% Complete]@row > 0.5, "Green", IF([% Complete]@row > 0, "Yellow", "Red")))

All comments

Darren Mullen

@BristolCVN Smartsheet reads if statements left to right until something is true. So, if your example. 60% is greater than 0, so it turns yellow.

You'll have to change the order and put the green condition before the yellow condition.

Paul Newcome

Give this a try:

=IF([% Complete]@row = 1, "Blue", IF([% Complete]@row > 0.5, "Green", IF([% Complete]@row > 0, "Yellow", "Red")))

BristolCVN

It worked! Thank you both!

Paul Newcome

Happy to help. 👍️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.