Why showing data as #NAME? #VALUE!

[kvngo94]

Hello guys, 

Hope you can help me with the below issue

I sourced data from Excel (onedrive) to AppSheet, but in appsheet it's showing errors as below

I don't know why it's showing like this, hope you can help me explain

1. Excel 

2. AppSheet setting

3.  Appsheet errors

[WillowMobileSys]

Those are not AppSheet errors.  They are errors in the sheet itself.  AppSheet is just displaying what the sheet sent. 

You need to find in the sheet, the row you are seeing in AppSheet and try to determine why the sheet is resulting in those errors.  The sheet will normally have a description of what is wrong.  Those errors are usually the result of some bad formula or bad data used by the formula.

[kvngo94]

Thank you for the suggestions

[SkrOYC]

Also, I would 99% of the time prevent the usage of any Spreadsheet expression.

[Almost] Always use expressions inside AppSheet

[kvngo94]

Thank you, I will try to use expressions inside AppSheet and keep Spreadsheet as a database