Really silly question but I can’t seem to figure out how to hide a single row. I have a chart view but the bottom row of the google sheet is TOTALS that I don’t want to show on the chart, but also don’t want to delete the row as these values feed another table.
Sure this is very basic, but any help would be greatly recieved.
On one of my columns is the row title “Totals”. I have gone to column view and then edited the “Show?” field to say [COLUMN]<>(Total)… this was suggested on a youtube vid.
Yeah it feeds other charts so that it updates different sheets that these graphs then use.
So basically I have a series of charts, one has totals at the bottom row of a column - I don’t want these to show on the chart. BUT the total are used in a formula on another app to populate fields that are used for other charts/calculations. Im not great at explaining this sorry
Maybe you could change this by using actual AppSheet expressions instead.
Btw, are your totals being use on any other place different than AppSheet?
I understand that this may sound like a good idea, but I suggest you to stick to the official docs. Any other source of info may help you but it’s more helpful when you already have a base knowledge of the platform since each person adds their own method/opinion.
What you are trying to do is to hide a row, not a column, so the way to go that doesn’t need any change to your GSheet is using a Slice, as @Marc_Dillon already suggested.
Slices has a “row filter condition” meaning that it will only show the rows that return true to your expression.
Find the column that has the “Total” word or, if the Key column is blank, you should be good to go with something like this:
ISNOTBLANK([_THISROW])
Anyway I suggest you to check what an AppSheet friendly worksheet is