Does appsheet apps recognize tables and it formulas from excel?

Does appsheet apps recognize tables and it formulas from excel?

Yes you can work with Excel files as well.

Hi Ajeski,

How to get formula in excel table to work when it’s inserted into Appsheet app development project. I used formulas to add some cells values in a table. It’s working very fine in excel but, failed to work in my app project. Please can you help?

Hi @Skyspacestravel_LTD
What are you trying to do and what are your formulas?

1 Like

Hi Lynn,

Many thanks for reply. I’m trying to calculate some cells value into a cell with a formula:
=c2*c3 into c4.

It worked fine in excel but.it wouldn’t work when used in Appsheet app

1 Like

Hi Steve,

I’ve used the formula correctly as stated in Expression: The Essentials as in ‘C4’ I entered ‘=C2*C3’ but, It still did not work, I got error message: #VALUE.

Are you entering your formula in a spreadsheet, or in AppSheet?

I entered the formula in the spreadsheet.

What does this have to do with AppSheet, then?

Hi Steve, That’s the formula I used in spreadsheet as you’ve requested. The formula I used in Appsheet is: [Number_1] * [Unit_Cost_1] to get the value in Total_Cost Column.

You’ve provided a lot of conflicting information.

Please provide a screenshot of the error.

Hi Steve,

Many thanks for your help. Please find the screenshot attached.

(Attachment APPSHEET SCREENSHOT.pdf is missing)

Hi Steve,

Many thanks for your help. Please find the screenshot attached.

(Attachment APPSHEET SCREENSHOT.docx is missing)

I want to MULTILY the value in column ‘Number_1’ by ‘Unit_Cost_1’ and display the result value in column ‘Sub_Total_1’.

image

Please provide a screenshot of the AppSheet error.