How to automate the RYG status balls

Janice Phua

I need help to automate the RYG status balls in the "Status" column, depending on the "% Complete" for each request.

This is my formula but it kept showing "Red" though I have % Complete is 75% and 100%

=IF([% Complete]@row < 70, "Red", IF([% Complete]@row > 70, "Yellow", IF([% Complete]@row = 100, "Green")))

Requirement:

If a request is less than 70% complete, turn the "Status" column into a "Red" status ball

If a request is 70% or above and less than 100% complete, turn the "Status" column into a "Yellow" status ball

If a request is 100% complete, turn the "Status" column into a "Green" status ball"

Find more posts tagged with

Accepted answers

Bassam Khalil

Hi @Janice Phua

Hope you are fine,please use the following formula:

=IF([% Complete]@row = 1, "Green", IF(AND([% Complete]@row >= 0.7, [% Complete]@row < 1), "Yellow", "Red"))

the following screenshot shows the result:

All comments

Bassam Khalil

Hi @Janice Phua

Hope you are fine,please use the following formula:

=IF([% Complete]@row = 1, "Green", IF(AND([% Complete]@row >= 0.7, [% Complete]@row < 1), "Yellow", "Red"))

the following screenshot shows the result:

Janice Phua

Thank you @Bassam Khalil it works now 😀

Bassam Khalil

@Janice Phua

You are welcome and I will be happy to help you any time.

Bassam Khalil

@Janice Phua

I will be grateful for your "Vote Up" or "Insightful".

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.