I’m working with some excel worksheets I’m using as calculators of sorts, using lookup tables etc. Am I able to assign fields in the app to certain cells in the excel, and have the calculations run, then have the output values displayed in the app? Or is there very strict formats that the app can follow?
Hi @Dan_Buckingham, If your question is regarding having formulas in spreadsheets that connect with an AppSheet app, yes
AppSheet supports spreadsheet formulas and display the results in the App.
There are some guidelines and rules on using spreadsheet formulas in the App. Please browse at