Check Box Based on Another Cell Containing Certain Text

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!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!