Checkbox, Texts, RYG

Nana250 ✭✭✭✭
edited 08/18/23 in Formulas and Functions

I am trying to create a formula based on checkbox and dropdown list column.

The result I am looking for is for Column 3 to have either a Red or Green symbol based on if Column 1 is checked OR Column 2 includes a specific word. Column 2 is a drop down with multiple options.

Is this possible?


Best Answer

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭
    Answer ✓


    Try this format and update columns names as needed: =IF(OR(CONTAINS("Insert Word", [Column 2]@row), [Column 1]@row = 1), "Green", "Red")

    If column 1 is checked or it finds the word in Column 2 it will go green, if not Red. Adjust as needed.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!