Keep Original formulas when adding a new row

[Rick_Reis_15]

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"

[Rick_Reis_15]

I've already tried changing the "formula" or "initial value" in the Data table in AppSheet, but it doesn't add the formulas to the new rows.

[Marc_Dillon]

It is recommended that your data source backend is just a plain store of data. Stop using formulas in your sheets, set it all up in the app. A spreadsheet formula of =if($C2="-";"-";) can easily be converted to an Appsheet expression to put into Initial Value... IF( [col2]="-" , "-","")     (*kind of a pointless formula if you ask me though*).

I think you mostly just need to learn more about how appsheet works, and then you'll see that what you're wanting to do is not what you should be doing. 

This post also seems like a bit of an "XY problem". As in you've seemingly already decided how you think you should solve your issues, Y solves X, and so you've asked us how to do Y. But what you should be doing is stepping back and asking us how to solve X.

[Rick_Reis_15]

Thank you.

1) But if I set all the formulas in the app, i can't use properly the Google Sheet in the computer, right?
Because this system is created to be filled from one person in the app and another person in their computer (not in the app).

2)As I said in my last post, I tried the formula in the Initial Value, but it doesn't work. Did i do something wrong?

---

@Rick_Reis_15 wrote:

I've already tried changing the "formula" or "initial value" in the Data table in AppSheet, but it doesn't add the formulas to the new rows.

---

[Marc_Dillon]

Another recommendation: if you're going to build an Appsheet app, don't allow anyone to directly access the GSheet. Trying to accommodate both is a bad idea.

I don't know if you did something wrong, your initial value expression is not visible in your screenshot.

[Rick_Reis_15]

Thanks.

I apologize if I incorrectly gave the impression that I came here determined to get Y answers instead of X.

As you can see, I'm quite new to Appsheet concepts. And I realize that I'm not making the objective use of what the app was created for. My initial goal was to have an app that complements Google Sheets and not completely replaces it (being used only for the backend), as unfortunately some features of AppSheet are still very limited, such as entering data with ctrl+c/ctrl+v, highlight specific cells with colors (without that big circle to highlight) and google scripts. (or maybe I still don't know how to use these functions in appsheet).

Anyway, thanks a lot for your answers. I will study all suggestions given.

Thank you.