I'm fairly new to app sheet. I have a spread...

expressions
(The Turbonator) #1

I’m fairly new to app sheet.

I have a spread sheet that people will populate using the app.

I have a column that’s listed as “Spot Check” with that can be answered via a

yes or no button however I only want the yes or no button to appear every 6 lines.

I have been messing with the show_if expression however have been unsuccessful.

Any ideas?

(Aleksi Alkio) #2

May I ask what formula have you tried already?

(The Turbonator) #3

I have tried listing the actual column numbers in the show_if field of the columns that I want displayed.

My spreadsheet only consists of 26 lines so I only have to show the Yes or No buttons 4 times. For instance,[_RowNumber]=6, [_RowNumber]=12, [_RowNumber]=18, [_RowNumber]=24

(Aleksi Alkio) #4

I believe when you are talking about the “every 6 lines”, you are meaning “lines” on your form view, correct?

(The Turbonator) #5

Yes correct, sorry for the confusion.

(Aleksi Alkio) #6

Instead of using [_RowNumber] you could just hide those fields with a simple expression FALSE (With Show?).

(The Turbonator) #7

Awesome! That worked! Thanks!!!