Expression was unable to be parsed.

Bonsly
New Member

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

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!

 

0 1 150
1 REPLY 1

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.

Top Labels in this Space