Add Footers to Structured Tables

Hey there!

Just added a video about Footers. It is a bit clunky on how to add them (as of now), but figured I would share!

TLDW: Add a Footer (aka #TOTALS) to a structured table in google sheets by:

Have an unstructured row under the table
- if the table goes to the end of your workbook, go to the top left table name menu dropdown > Adjust Table Range
Use a function in that unstructured row directly below the table, like SUM(), and use a table range as the argument.

It should grey out the end row as the footer!

It has worked for all my accounts (personal, work, etc.) Hopefully it does for you all! I also used Chrome as my browser.

A couple of things I noticed after I created the video:

When you add a footer, the only way (I found) to remove it was by setting the table to “unformatted” then recreating the table. Just a warning!
It doesn’t change the GROUPED View - or rather show totals for those unfortunately…Hopefully that will happen sometime.

Hopefully you find this helpful! I’d be curious about your thoughts on this update, as well as other features you hope will be added to it as well!

Cheers!