Conditional formatting, status balls don't change colour

Francesca Gallisai

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

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