Conditioning logic to be AND not OR in form

Lindsay Starling

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

DesireeJones

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! :)

DesireeJones

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! :)

Lindsay Starling

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 :)

Andrée Starå

Hi @Lindsay Starling

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!

mbrenn207

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?

mbrenn207

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