#Unparseable error after saving from android app

resq93

For some reason my formulas are suddenly showing #Unparseable after the sheet was updated on the mobile app. Not sure what is wrong, can anyone take a look?

https://app.smartsheet.com/b/publish?EQBCT=5682096f4bf44ebda10e855be7e57aa6 

Ty

 

M

Shaine Greenwood

Hi M,

Looks like something happened to cause the square brackets [ ] to be stripped out of your cell reference in your formula.

Add the square brackets around the name of your column name in the formula and copy it down your sheet, e.g. [Exp Date]1

More information on creating formulas is available in the help center: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet

If you find that the formulas become converted back to the incorrect syntax on mobile again, reach out to our Support team so we can troubleshoot the issue with you further.