RYG based on Status

System

This discussion was created from comments split from: How to automate the RYG status balls.

Sana

Hello, I need urgent help. I want to automatically update the RYG status balls in the "Health" column, depending on the "Status" column.

this is the formula

=IF(Status46 = "Complete"; "Green"; IF(Status46 = "In progress"; "Yellow"; IF(Status46 = "Not Started"; "Blue"; "Red")))

but it keep showing "red" as text in the column instead of updating the color of the ball, However i have chosen symbol for "Health" column and limited it to symbols only.

Please help how can i have a ball symbol instead of text

Paul Newcome

@Sana It is case sensitive. It looks as if the formula in the sheet has "RED" instead of "Red". Try fixing that and see if it works as expected.

Can you also provide a screenshot of the column properties as well as the exact formula copy/pasted directly from the sheet to here?