Hello! I have a system in google sheets in which some columns (the ones with the blue header) have an "arrayformula" (and it works great when I add a new row VIA the AppSheet) and other columns (the ones with the yellow header) that have an initial formula:
=if($C2="-";"-";)
which can be overwritten by a simple text, entered manually. Finally, the columns with green headers do not have formulas and are only for manual insertion of text.
My system
Here you can see the "original" formulas in the blank rows
So when I need to create a new row at the end of the table, I need to copy the formulas (yellow header) so that the row works as I wish. THE PROBLEM IS when I try to add a new row through the AppSheet, which creates this new line without any formatting or the original formulas.
1) How can I insert a new line through the app (OR another solution, like using an existing line) with the same pattern as the original lines?
New row created by the AppSheet in the end of the sheet
2) I have another sheet with the same pattern. Is it possible to copy data from this other sheet to my main sheet, overwriting an existing line? To prevent me from losing this formatting and formulas? (I created an Action: "Data: add a new row to another table using values from this row", that works well, but it creates the new row exactly like the image above.
The action "copy data"
User | Count |
---|---|
18 | |
14 | |
11 | |
7 | |
4 |