Sign in to join the conversation:
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
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.
I am trying to setup a sheet that can project dates decades into the future. I want a formula that can look the date in the row above, check to see if it's annual or quarterly, then add the appropriate number of months to each row. While testing the formulas, I keep getting stuck on how to add one year (12 months) to each…
Good morning, I have a document that I download from an outside source. I have set up a data shuttle to import it into Smartsheet. I have other sheets that need to be updated based on the info in the imported sheet. None of the formulas are working once a new file is imported. Details: Sheet imported through Data Shuttle…
I have a form adding new rows to my smartsheet but it doesnt add the next number in the primary key, is there a way to do this?
