Does appsheet apps recognize tables and it formulas from excel?

Web_Master
Participant II

Does appsheet apps recognize tables and it formulas from excel?

0 15 518
15 REPLIES 15

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?

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

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?

Please provide a screenshot of the AppSheet error.

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โ€™.

2X_9_9598ff52c20025eee05829b0bfec08360c17f62d.png

Top Labels in this Space