Updating a cell based on checkbox column and a multi-select column
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
Help Article Resources
Check out the Formula Handbook template!