Spreadsheet Formulas when completing the Import CSV action

[oshyd]

Hello all,

I have an issue where I have set up an action to import a certain section of data within my spreadsheet. When the data has been imported the cells where there is a spreadsheet formula are not calculated as the import carrys through a blank cell.

Is there any way to fix this without the me or the user going into the spreadsheet and manually dragging the formula down.

[dbaum]

Confirm whether the spreadsheet formula reliably propagates when adding a row via an app form view. If so, then you should report to AppSheet Support the issue related to importing csv. Meanwhile, the only mitigation is likely to intervene in the spreadsheet--either manually as you suggest or potentially automating to some degree via Apps Script.