Conditioning logic to be AND not OR in form


Hi there,

I am needing to build in logic to a form whereby a question shows if a specific answer to 1 AND 2 is selected and not OR.

Question 1 : A, B or C

Question 2: X, Y or Z

Question 3: Appears if answer to Q1 is C and answer to Q2 is Y. Currently this is showing if answer to Q1 is C or if answer to Q2 is Y. I need it to only show if both criteria are met.

Many thanks

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!