Does NOT contain formula

Hi everyone. I am trying to come up with a formula that provides a solution to this:

Column "Product" contains a multiselect dropdown with X, Y and Z as options.

Colum "Type" contains a dropdown list with multiple selections available, but needs to reflect "N/A" IF "Product" column as any combination of selections that does NOT include Y and/or Z.

So basically somthing like IF(product@row) NOT("X"), "N/A"

I know that isn't and actual formula but trying to express what I am looking for.

Thanks in advance to the great minds on there that understand formulas way better than I do!🙂

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!