RYG based on Status

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


  • 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
    Paul Newcome ✭✭✭✭✭✭
    edited 03/09/22

    @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?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!