I am currently working on app for portfolio tracking and multiple of my view require freezing first column and row in table view. as well as it requires summation of all value in the column in the last row.
I know there are similar posting asking this same question (around 2020/2021) with some answer suggesting the feature is under the development but in current version (2026) of appsheet that i am using (with the help of Google Gemini), there is no option to freeze column or row or adding summary row at the bottom of table which shows summation of the column value (same what we can do in excel).
Based on AI, appsheet don’t support this features anymore in 2026 version of the appsheet (previous feature removed).
Are you using data from Google Sheets? If yes, create a ticker column in column A (the first column) and then generate the structure. Or you can change the ticker column to label. Good luck.
If you want to keep the first row of your records fixed (in addition to the headers), you can use the “Sort by” option in the view settings and add a column for sorting. This column should have a value that ensures the desired record always stays as the first row.
To have a SUM row at the bottom, you could create a BOT that inserts a total_line record if it does not exist yet, and updates the allocated column with the SUM of the relevant records. You should also add a flag to identify this row as the total line so it does not trigger other automations or actions meant for normal records. The same “Sort by” column can also ensure the total row always stays at the bottom.
Thank you. Your suggestion to enable “preview” worked very easily. It automatically started freezing first column in all the view that uses table and I wanted that !
However, I wanted to freeze the header row (1st Row) as well but your “sort by” option isn’t providing the solution I am after and same as for creating BOT for summation at the end of column. What you suggested for this two item is the work around rather then inbuilt feature of the appsheet and it is high maintenance as it requires me to change things in my google sheet for “summation” on the last row of the table.
Thank you, at-least you provided good solution to freeze the first column ! it helped a lot !
If your data is small, the first row of freeze will not be visible. Try making your data more than one display screen, then the first row of freeze will be visible. If you want a sum like this
I have used group by function before and it works where i can group items in category like all “buy” trade or “sell” trade but what i need is summation under this three column which is part of the table view with 6 other columns. i don’t need summation to other 6 columns.
i understand your point about “row” freezing works once i get more data so will check that as i add more data.
If you want to do this and are using Google Sheets, you can do it by first converting your data into a table and then creating a new table using the results of that pivot table. The result will look like this.
For the sum of all values change the display name for the column to use an expression to show the sum. You can use CONTEXT() so that AppSheet only shows the sum for the view you want it to appear on.
What you suggested is clever workaround, but it basically sum all the value and put it into the header row like in my screenshot below. I can fix the decimal but it’s not ideal to have tital with sum value next to it. I need total summation at the last row.
Thanks. Yes, I am looking for something like your screenshot which basically sum up all the value in the column at the bottom last row. I am using google sheet for my data but i don’t need pivot table for my need because it’s not dynamic information at the moment which work based on filter selected.
so you suggesting that i add summation row at the bottom of the table for “total cost” and then the table in the appsheet also shows that sum ?
There is issue in this method because i am having multiple user and each user email id is also in the table to identify their data now user add data randomly so U1 has 3 row then U3 has 2 then U4 has 1 an so on so adding sum at the bottom simply add all the value above and don’t filter based on user in googlesheet. not pivot table can help with this issue but again i wanted appsheet to be smart to simply add all value in the column above as appsheet automatically filter data based on user who is signed on the account.
i will probably leave feedback for appsheet to add this UX function in table view to make life easier for all of us who uses appsheet and googlesheet combination.
