Updating a cell based on checkbox column and a multi-select column


Hi there,

I am new to SmartSheets and am struggling to use the CONTAINS formula. I need to allow for the option for [Trial Type] to be either Sales Strip, Sales Demo, or both Sales Strip and Sales Demo

The formula below doesn't work if both Sales Strip and Sales Demo are selected.

Do I need to use the CONTAINS function? Or is there another way to make this work if both are selected in the [Trial Type] column?

=IF(AND(Parent1 = 1, OR([Trial Type]1 = “Sales Strip”, [Trial Type]1 = “Sales Demo”)), TODAY(+10))

Thanks for your help

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!