I have a key column and it contains values that are considered both numbers and text, for example 1234 and 1234-1. This column also is they key of a table and acts as the criteria in several SUMIF(S) spreadsheet formulas.
Now I had to adjust spreadsheet formulas today and as a result I had to reformat some of my column types. Now AppSheet wont return a value for nearly all of the columns that contain a spreadsheet formula in which 1234 is included as the criteria #VALUE! error). Rows in which have 1234 “-1” are fine and return a value in AppSheet.
I have ensured the column types are the same between both AppSheet and Excel and it makes no differences ( i have regenerated and played around with formatting). The only thing that resolves it turning a 1234 into 1234-1. All of my formulas in Excel return.
Is this expected behavior? Is there a way to reconcile this