Addition of Columns in Google Sheets

[Kaushal_Didwan1]

Hi,

I have a columns startinf from A to X in google Sheets and have an app which maps that google sheet. Now I have added another column after ‘Column C’ but when I am trying to add a row using AppSheet, that Column is shown in the end and not after ‘Column B’. Can anyone help??

Also, I have added a Column Formulae in AppSheet, how can I update my entire sheet with that formulae?

[ycr]

First question:

So you have columns let’s say A B D E F… And you want to add a new column C, and want to make the table like: A B C D E F ?
One way is to modify the spreadsheet, right click column B and then “insert 1 right”, name the column, for example “C”. In Appsheet, go to data and go to Columns tab, click regenerate structure. Appsheet will pick up the new column C in your app.

[Steve]

help.appsheet.com

Columns: The Essentials

Once you have tables in the editor, you can use the Columns tab to categorize each column and give it a role in the app.

help.appsheet.com

How to add, remove, or rearrange columns

Regenerating your columns is a necessary step in making sure changes in your spreadsheet are reflected in your app's structure.

help.appsheet.com

Working with a Spreadsheet and the Editor

How to understand and control the process of getting your spreadsheet to work well with the AppSheet Editor.