Can someone please advise how to transform this exel sheet into App sheet, Mainly formulas

[RMAUS]

I need help mainly with the formulas . Thanks in Advance

[VarunChandran]

 Go to Appsheet.Com and login with your microsoft credentials. Create New App. Choose the data source from your OneDrive or Sharepoint.

Once you connect your table in Appsheet. The Formulas will be automatically updated. 

Go to the table and click the column details.

Under Auto Compute you will see your spreadsheet formula.

[RMAUS]

App sheet did not take the formula fro the spread sheet.

[Trevwiller]

The formulas do not transition into the app. The app can use sheets that have formulas running in them (they do recommend against it) but can work. You will have to input all the formulas as you need them into Appsheets manually.

They are different from spreadsheet formulas as their actions and inputs speak a different language than the spreadsheet.

Here is the appsheets expressions list (these are the only "legal" formula units in appsheets):

https://support.google.com/appsheet/table/10104782#query=

You can expand your use cases by running code embedded in the sheet, Pairing with app script, APIs, or AI

[Trevwiller]

I wanted to check back in and see if your issue has been solved?

[RMAUS]

@Trevwiller Nope, i wasnt sure which functions to use as we need to use the data from the spread sheet.

[Kurniawan-Haria]

You can start uploading your exel to google and save it as sheet. On the new google sheet you can delete all the formula columns. Than you can created a appsheet using your google sheet as database. Inside Appsheet you can recreate the formula columns as virtual columns replaceing the cells address with the column names.
Hope that make sense and what you wish to accomplish.