Lynn’s suggestion is a good one and should help.
Here is what is going on.
AppSheet uses heuristics to find the header row.
In your case, it appears you have a table with a single data column and all of the data values in that column are short text strings. This is a worst case scenario for our heuristic for finding the first data row.
- There are very few columns and very few rows for our heuristic to examine. 2. All of the column values contain short text strings. Such short text strings look a lot like column headers. 2. Our heuristic looks for words that are common in headers. In your case, row two contains the word “commission” which is one of common header words we explicitly look for. That is causing the heuristic to weigh the row as a likely header.
Our heuristic treats rows in bold text, as more likely header row. That is why Lynn suggested making the header row bold. Doing that will increase the likelihood the first row will be recognized as the header row.
If that is not sufficient, you can also try moving “commission” down into a later row. The farther the row is from
the top of the worksheet, the less likely we consider it to be the header row.
If all else fails remove “commission” from the list, do the inference, and then restore “commission” after the inference finishes.
If none of these things work, please let me know so I can help you further.