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.
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
