Conditional formatting, status balls don't change colour

Hi!

I'm using this nested-if formula to automatically update the status ball:

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

The status ball, however, stays red for all rows, what am I doing wrong? The sheet can read the formula but the status doesn't get updated.

This are the "rules" I want to apply:

If [% Complete]@row less than 70% complete, turn the "Status" column into a "Red" status ball

If [% Complete]@row 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

Formulas

Accepted answers

All comments

John_Foster

Hi @Francesca Gallisai,

The % complete column is normally a decimal value in the background, so 70% equates to 0.7 and 100% equates to 1. Try amending the values and removing the quote marks and see if that helps.

John

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.