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!🙂
Help Article Resources
Check out the Formula Handbook template!