Forms, field logic

Razetto

I want to set up a field with a yes/no answer and with the following logic: if answered "yes" then show the fields d,f,g (i want these as required fields); and if the answer is "no", show the same fields d,f,g but as optional to answer. So the same fields are showed regardless of the answer, but depending on the answer the field is a required one or not. I haven't found a way to do it, is there a way around it?

David Joyeuse

Hi @Manuel Razetto

I don't think it's possible as straight as you'd like it to be.

One workaround could be to have 2 sets of fields that I would call D1,F1, G1, that you'll display when answer is "YES" and makes them required. The second set would be D2, F2, G2 that you would display when answer is "NO" and makes them optional.

Then in your D, F and G fields use that type of formula:

=IF([Yes/No Column]@row = "YES", [D1]@row, [D2]@row)

You can also makes those helper fields hidden on the sheet if you want.

Hope it helped!