Why showing data as #NAME? #VALUE!

AppSheet AppSheet Q&A
1

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

kvngo94_0-1649042254434.png
kvngo94_0-1649042254434.png1651×427 36.1 KB

kvngo94_1-1649042267989.png
kvngo94_1-1649042267989.png1644×361 31.5 KB

  1. AppSheet setting

kvngo94_2-1649042447481.png
kvngo94_2-1649042447481.png1252×667 41.8 KB

  1. Appsheet errors

kvngo94_3-1649042473454.png
kvngo94_3-1649042473454.png946×270 7.29 KB

2

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.

4 Likes
3

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

[Almost] Always use expressions inside AppSheet

3 Likes
4

Thank you for the suggestions

1 Like
5

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

2 Likes