Hide a row

Hi,

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.

Thanks All

  1. Remove the totals row
  2. Don’t use your database outside AppSheet

That’s just IMHO

2 Likes

Use a Slice.

2 Likes

Its still used in Appsheet and feeds into other data tables so can’t remove the row… unless there is something Im missing (Very Possible)

Thanks

I have made a slice, but not sure how to make that not include just this bottom column. Could you please advise?

Set a condition that excludes the key value of that row.

1 Like

Is this the kind of row that automatically goes at the bottom of your table showing totals/averages and more? If it is, what’s the purpose of it?

Sorry, still confused :grinning_face:

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.

Sorry - Im befuddled!

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 :thinking:

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

Make an “AppSheet-friendly” spreadsheet - AppSheet Help

1 Like