Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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.
Hello, I have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
Hi all, reaching out to see if of you have ideas; I'm hoping this makes sense: I'm having some trouble getting my formulas to pull data in correctly. I currently have a sheet (primary data) where I have data in rows where each row is a single project, with columns identifying persons, $ values, unique project identifier,…
I have a sheet with 5000 rows and 30 columns. with 4 columns of them are formular columns. How can i reach this limit for 25000000 formular cells reference? How can i enlarge this limit? I need those formular to link some data from another sheet as there is also Max cells limit for one sheet. How can I join those data…
