Check Box Based on Another Cell Containing Certain Text

Nancy Heater

Good afternoon Smartsheet!

Looking for assistance to making this work.

Let's say I have a check box column for "Contains Potatoes"

I need this box to automatically check if the column for "Entree Sides" contains the word "Potato".

Thanks!

Andrée Starå

Hi @Nancy Heater

I hope you're well and safe!

Try something like this.

=CONTAINS("Potato", [Entree Sides]@row)

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Nancy Heater

I hope you're well and safe!

Try something like this.

=CONTAINS("Potato", [Entree Sides]@row)

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Nancy Heater

@Andrée LaRivière ... perfect. I knew I was way over thinking it!

Thank you, and have a great weekend!

Andrée Starå

@Nancy Heater

Excellent!

You're more than welcome!

David Brandt

@Andrée Starå@Andrée Starå Expanding on this... how would you adjust your formula if the tick box column wasn't limited to potatoes and you wanted to tick a box if, say, carrots or beets were also Entree Sides?

David Brandt

I was thinking something like...

=IF(OR(CONTAINS("potato", "carrot", "beet"), [Entree Sides]@row]), 1)

...but can't get this to work.

Smartsheetuser71

Hi! If I want to create a single checkbox column next to a multi checkbox column that will automatically checkmark if the multi checkbox column has "new" check marked, how do I do that?

Genevieve P.

Hi @Smartsheetuser71

Try something like this:

=IF(HAS([Multi Checkbox]@row, "New"), 1, 0)

Cheers,

Genevieve

Smartsheetuser71

Thanks.