Formula with Symbols

TolerDo

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!

Donna

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.

Sample:

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

Thanks! I will give this a go!