Trying to Input a formula to automatically generate a symbol

I have a column where I am tracking percent met and I want that percent to trigger a symbol in the column next to it. The symbols I am using are the 5 circles (Empty, Quarter, Half, Three Quarter, Full). This is the code I tried

=IF([Percent Met]3, =100, "Full", IF([Percent Met]3, 99.9 > 75 "Three Quarter", IF([Percent Met]3, 74.99 > 50, "Half", IF([Percent Met]3, 49.99 > 25, "Quarter", IF([Percent Met]3, 24.00 > 0, "Empty" )))))

Find more posts tagged with

Formulas

Accepted answers

All comments

Purnima Gore

Try this

= IF([% Complete]@row < 25, "Empty",

IF([% Complete]@row < 50, "Quarter",

IF([% Complete]@row < 75, "Half",

IF([% Complete]@row <100, "Three Quarter",

"Full"))))

It goes into a single row next to each other but have separated this so you can see the construction

This gives you the result. You can use any numbers or % I have used % Complete for ease.

Hope that helps

ATB

Purnima

Paul Dieterich

That worked, thank you!

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.