Expression was unable to be parsed.

AppSheet AppSheet Q&A
1

Hi, everyone! Was looking ask for help. It’s my first time using appsheets and by no means any expert on using google sheets as well, but I’ve been following a tutorial on how to create a POS using the platform.

I followed it and things were smooth for a while until I encountered this error:

Bonsly_0-1658491822186.png
Bonsly_0-1658491822186.png1197×789 60.3 KB

I’ve set all of the validity statements to all of the [Quantity X] to [_THIS]>=1, but this is the only column that has this error. Any advice on how to fix this? I would really appreciate it. Thanks a bunch!

2

You have mentioned about validity constraint, but the error is mentioning editable_if constraint. You may wish to check if you have an invalid formula in [Quantity 3] column’s editable_if setting. There seems to be an inadvertent “=” entered in that constraint.

1 Like