#Unparseable error

Hi I am new to Smartsheet, I am trying to calculate a row call Total Billable for each month of for our total amount of jobs completed.

The format I'M using is as follows: -

=SUM(Total Billable820:Total Billable828) it comes up with the error #Unparseable

Can someone please advise me what I am doing wrong?

Capture A.JPG

Find more posts tagged with

Government

Support

Comments

Andrée Starå

Hi,

Try this,

=SUM([Total Billable]820:[Total Billable]828)

When you have spaces or numbers in the columns, you have to put the column name in brackets.

Depending on your specific use case and sheet structure it could be helpful to use hierarchy with parent-child relationship to sum a section like above.

=SUM(CHILDREN())

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

c.carstens63826

Good afternoon

It has worked perfectly.

Thank you

Andrée Starå

Great!

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
Autonumber Not Working
Hi, We I use the edit column properties and select autonumber, the sheet no longer generates a number. Please help.