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.
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…
I'm officially stumped. I'm tracking Admissions Reps visits to schools, the types of visits and the amount of visits and inquiries. The columns are as follows: Created Date Rep Name Type of Event 1 - Dropdown: Tabletop, College Fair, Classroom Presentation, School Visit, School Tour District 1 - Dropdown with all Districts…
