Two columns are checked then want separate column to show green

Sborror

If one column is checked and one is not want to show yellow

if both columns are unchecked want to show red.

Kimberly Loveless

It sounds like you need a nested if statement. It sounds like you already have the symbol column for the colored ball icons. Your function would look something like

=IF(AND([Column 1]@row = 1, [Column 2]@row = 1), "Green", IF(AND([Column 1]@row = 0, [Column 2]@row = 0), "Red", "Yellow"))

This is what it would look like in the sheet

Kimberly Loveless

It sounds like you need a nested if statement. It sounds like you already have the symbol column for the colored ball icons. Your function would look something like

=IF(AND([Column 1]@row = 1, [Column 2]@row = 1), "Green", IF(AND([Column 1]@row = 0, [Column 2]@row = 0), "Red", "Yellow"))

This is what it would look like in the sheet

Sborror

THANK YOU!