I have an app that incorporates about 20 columns (each a formula) for each new row. I want to enable users to add a new entry in column A to the sheet and have the formulas carry down. However, I have yet to find a simple way to do this.
When a new entry is added, it does not carry down the formula. If I leave column A blank and prepopulate the formula columns, Glide entry comes in after the prepopulated rows.
Any help would be appreciated - in particular one that does not force me to reconfigure the entire app. I think this can be done with a second sheet but worry about reconfiguring the entire app.
I should add the the formulas are based on stock market data so I need to ensure I do not break the ability for the sheet to auto refresh (this is a pro account).