Two columns are checked then want separate column to show green

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

if both columns are unchecked want to show red.


Best Answer

  • Kimberly Loveless
    Kimberly Loveless ✭✭✭✭✭✭
    Answer ✓

    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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!