I am trying to figure out how to do a IF in a form
For Example IF([ROW1]=“NO”,IF([ROW2]=“YES”,SHOW QUESTION,DONT SHOW QUESTION),DONT SHOW QUESTION
So if row 1 is NO but if ROW 2 = YES show the question but if ROW 2 is not YES and ROW 1 is no dont show the question.
Hopefully someone can help me with this.
@appteam6
I think you can do it like this:
presses the “Show expanded View” and add a formula to the Show?
But I am NewB in Appsheet and I havent had the need to test this…
The IF formula is up to you…
but if you need two conditions to be true, I think you need to use AND () combined with IF ()
When this is a formula for Show? option, you can do that just like…
AND([Row1]=“No”,[Row2]=“Yes”). If they are both TRUE, it will show your column.
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |