I’m struggling with plus sign (+) . when I type a text begin with “+” on appsheet , I notice that corresponding cell on googlesheet is turned to a formula #ERROR! !!!
I have this problem only with the sign (+) but in contrary the sign (-) googlesheet adds automaticlly an apostrophe ’ to avoid turning the cell to a formula
I change the format of the sheet from number to plain text but I still have same problem .
I replicated exactly what you observed. I formatted the sheet column as plain text, and no apostrophe was prepended or necessary for the value beginning with a minus sign. While the value that begins with a plus sign is retained in the sheet, the resulting error means it’s unavailable to the app. If you didn’t already, I suggest at least report to AppSheet Support, although it may not be fixed anytime soon–especially since this is a data source (i.e., Sheets) issue rather than an AppSheet issue per se.
Meanwhile, if you can’t avoid values that begin with a plus sign, you could experiment with workarounds like this quick, untested brainstorm:
"X" & [text column]) and Reset on edit triggered whenever your text column is updated.RIGHT([text column], LEN([text column]) - 1). Use this column wherever you need your original column’s intended value for display or expressions.And, actually, here’s another quick, partially tested idea. Either manually or automatically insert an apostrophe into the value. It looks like that gets suppressed once it’s saved to Sheets, and that’s reflected back to the app.
Please also explore if using an emoji character of + will work for you as suggested in the post below
Avoid taboo letters reserved for the system. You can make all text begining with +… be not valid and tell users not to do.
in Valid if : NOT(STARTSWITH([_THIS], “+”))
in In valid value error : “Do not start with +”
You can try format that column as text on google sheets.
I change the format of the whole sheet to plain text but stills same problem
sames good idea , I take it as an alternative solution … thank you
