HOW TO USE A FORMULA TO POPUALTE A STATUS BAR SYMBOL

Is it possible to create a formula that will automatically populate a status symbol selection based on a percentage entered? See my current formula and sheet below:

=IF(([Percent Complete]@row =1, "FULL", IF([Percent Complete]@row >=.75, "THREE-QUARTER", IF([Percent Complete]@row >= .5, "HALF", IF([Percent Complete]@row >= .25, "QUARTER", "EMPTY")))))

Find more posts tagged with

Accepted answers

Paul Newcome

@Monika_lnu and @AmarK You will want to change the logic for the "Half" argument to 50 instead of 5.

All comments

florian.zbinden7

hi,

you should use a Symbols column type

{ACF0D589-3816-455E-9C42-D4D2F34CAB40}.png

and then make sure the text matches what's required for this type of symbol

{8860A7B0-6D4A-468C-9B06-210B29398629}.png

{355A54F5-D5FA-44E9-B7E9-D6B1E986B325}.png

nicksnav

Morning @Brandon Morales!

It looks like in this instance the text is case sensitive. Your symbol text is all upper case. Your formula would need to be:

=IF([Percent Complete]@row = 1, "Full", IF([Percent Complete]@row >= 0.75, "Three Quarter", IF([Percent Complete]@row >= 0.5, "Half", IF([Percent Complete]@row >= 0.25, "Quarter", "Empty"))))

Brandon Morales

thanks- that definitely helped. still have an issue though- for some reason when a value should at the Quarter symbol it shows the half symbol… any suggestions?

Current formula below:

=IF([Percent Complete]@row = 100, "Full", IF([Percent Complete]@row >= 75, "Three Quarter", IF([Percent Complete]@row >= 5, "Half", IF([Percent Complete]@row >= 25, "Quarter", "Empty"))))

Paul Newcome

Your argument for half is greater than or equal to 5. Try changing that to 50.

Brandon Morales

YUP, THAT DID THE TRICK- THANKS SO MUCH!!

Monika_lnu

@Brandon Morales =IF([Percent Complete]@row = 100, "Full", IF([Percent Complete]@row >= 75, "Three Quarter", IF([Percent Complete]@row >= 5, "Half", IF([Percent Complete]@row >= 25, "Quarter", "Empty"))))

AmarK

=IF([Percent Complete]@row = 100, "Full", IF([Percent Complete]@row >= 75, "Three Quarter", IF([Percent Complete]@row >= 5, "Half", IF([Percent Complete]@row >= 25, "Quarter", "Empty"))))

Paul Newcome

Happy to help. 👍️

Paul Newcome

@Monika_lnu and @AmarK You will want to change the logic for the "Half" argument to 50 instead of 5.

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.