I'm working with some excel worksheets I'm us...

(Dan Buckingham) #1

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?

(Suvrutt Gurjar) #2

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

help.appsheet.com - Spreadsheet Formulas Spreadsheet Formulas help.appsheet.com