Checkbox, Texts, RYG

Options
Nana250
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?

Tags:

Best Answer

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

    @Nana250

    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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!