Checkbox, Texts, RYG

Nana250

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?

Nic Larsen

@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.

Nic Larsen

It would be something like this: =IF(AND([Column 1]@row = 1, [Column 2]@row = "Yes"), "Green", "Red")

1 = Checked

Nana250

This formula didn't pick up the specific word I needed in Column 3. I incorrectly post AND earlier where I needed an OR formula

Nic Larsen

@Nana250

What are your options in Column 2? Can they select more than one?

Nana250

Yes they can select more than one.

Nic Larsen

@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.

Nana250

YES!! Thank you!

Nana250

Hello @Nic Larsen - I need to revise this formula to add: if column 4 has a specific word it will bring up a yellow circle.