# Conditioning logic to be AND not OR in form

Options
edited 09/30/22

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

• ✭✭✭✭✭
Options

Hello @Lindsay Starling ,

Here is a potential formula generated with the information provided:

=IF(AND([Q1]@row = "C", [Q2]@row = "Y"), [Q3]@row)

If Q1 is equal to C and if Q2 is equal to Y, then show Q3.

I hope this helps! :)

• ✭✭✭✭✭
Options

Hello @Lindsay Starling ,

Here is a potential formula generated with the information provided:

=IF(AND([Q1]@row = "C", [Q2]@row = "Y"), [Q3]@row)

If Q1 is equal to C and if Q2 is equal to Y, then show Q3.

I hope this helps! :)

• Options

Thank you @DesireeJones however I am needing this logic in a form and not a sheet. It does not seem you are able to build in formulas to a form. Essentially I'm needing a fancier logic function :)

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

If I understand your need correctly, it should be possible to structure it with Form Logic.

What's not working?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Hi - I have the same issue. I have a form with 14 Yes/No dropdown questions. I want to display a statement to the user when 3 specific questions are answered Yes. However, the form only allows me to apply logic to each question individually meaning if the user answers Yes to the first flagged question, the statement populates. I need the statement to only show once all 3 questions are answered Yes. How do I accomplish this or is this simply not possible?

example: is it possible to change this OR statement to AND?

• Options

@Andrée Starå @DesireeJones - forgot to tag you on this thread :)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!