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.
Hey Smartsheet Guru’s I have 2 sheets – 1 is capacity and the other is ooto – Sheet 1 – capacity has names and emails and %the first 3 columns and subsequent columns has week to week start date(as text), end date as text and number of days excluding holidays In the OOTO file – it is a simple if someone requests timeoff it…
I have a sheet and I want the checkbox option to appear as checked if the cell in the name column of the same row is one of 133 options- is this possible in a single formula?
Hi there, since yesterday I have noticed that the Sheet Name column links in reports are not taking the user the correct row in the source sheet, as they have always done. There does not seem to be a pattern, sometimes it takes the report user to the top of the source sheet, or to a random row, or the odd time to the…
