IF formula issue (again)

I though this would be an easy one but it has me stumped again...

So i now want a column to populate with a symbol based on an other columns status to give a pictorial representation of that status, is this possible?

i.e.

The symbol option used was from the 'Status' section and was the empty circle running through to the full circle. I have 5 separate status options so the formula would repeat 5 times, each using a phase of the circle.

=IF(Document Status@row = "example here", rest of the formula to get an empty circle,

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

If you click on the dropdown arrow in a cell in the symbol column, you will see what text outputs you need to have for each different symbol (case sensitive).

From there it is a basic nested IF statement.

Example:

=IF(Status@row = "Not Starterd", "Empty", IF(Status@row = "In Progress", "Half", IF(Status@row = "Complete", "Full")))

All comments

Paul Newcome

If you click on the dropdown arrow in a cell in the symbol column, you will see what text outputs you need to have for each different symbol (case sensitive).

From there it is a basic nested IF statement.

Example:

=IF(Status@row = "Not Starterd", "Empty", IF(Status@row = "In Progress", "Half", IF(Status@row = "Complete", "Full")))

paul112233

Great thank you, i'm learning a lot guys :-)

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.