Formula with Symbols


Hi Smartsheet friends,

I would like to use the red/yellow/green symbols, and need some assistance with the formula

I have a series of checkbox columns; each column represents a task.

When all are checked (true) = green

When some are checked = yellow

When none are checked = red

Thank you!




  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @TolerDo,

    You can use a nested IF & COUNTIF formula.

    In this example you have 3 checkbox columns "Check 1", "Check 2", "Check 3" adjacent to one another.

    In your RGY symbol column:

    =IF(COUNTIF([Check 1]@row:[Check 3]@row, 1) = 3, "Green", IF(COUNTIF([Check 1]@row:[Check 3]@row, 0) = 3, "Red", "Yellow"))

    This checks if they're either all ticked (in which case, the symbol is green), none of them are (symbol is red) and if somewhere in between then yellow.


    If your columns are not adjacent then you can adjust the formula to do similar, it'd just be like this:

    =IF(COUNTIF([Check 1]@row, 1) + COUNTIF([Check 2]@row, 1) + COUNTIF([Check 3]@row, 1) = 3, "Green", IF(COUNTIF([Check 1]@row, 1) + COUNTIF([Check 2]@row, 1) + COUNTIF([Check 3]@row, 1) = 0, "Red", "Yellow"))

    Hope this helps point you in the right direction, but if you've any problems/questions then just post! 🙂

  • TolerDo
    TolerDo ✭✭✭

    Thanks! I will give this a go!