How to autofill a "Yes No" question based on the previous answer

[TrassaE95]

Hello,
I searched the question and am new to appsheet, and didn’t find a clear answer. I have a simple sheet set up. There are 5 questions. I would like to have the functionality of -

“If question 1 =Yes, question 2, 3, 4, and 5 =No”

I have tried messing with it, and I am using dropdowns in google sheets to set the yes or no option. Any help is greatly appreciated. Thank you!

[takuya_miyai]

Hi @TrassaE95

I think you can achieve this by setting the following as the initial value

IFS([question1], FALSE)

Something like this. Does it meet your expectations?

By the way, the expression above means the same as the following.
IFS([question1]=TRUE, FALSE)

Thanks,

[TrassaE95]

That is the exact functionality I am looking for, but it isn’t working for some reason. I click on the first question, and nothing happens. I placed the script in Initial Value, and used the insert column name, mimicked the bracketing that you have in your example, and it doesn’t function like in your demo. I am not sure why.

[takuya_miyai]

@TrassaE95

Is the question columns a yes/no type?

My sample expression is supporsed to be a Yes/No type.
If it is text type, etc., you will need a different expression.

[TrassaE95]

I changed it to formula and it works now. Thank you for all of your help!

[Steve]

TrassaE95:

I am using dropdowns in google sheets to set the yes or no option

AppSheet cannot respond to changes made directly to the spreadsheet by the user.