Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.


Steven Stone
edited 12/09/19 in Archived 2015 Posts

I can't add a column of numbers.  

I've entered =SUM([Amount]



Keep receiving UNPARSEABLE error.

Is this incorrect?



  • Bryan Anderson

    Have you check the capitalization of the column name?



  • Steven Stone
    edited 06/22/15

    Here's a screen shot of the column.

    I'm not sure I understand your answer.

    Should Amount be capiatalizaed?

    Also if you will notice the column and cell don't appear to be lining up for some reason.



  • Bryan Anderson

    The capitalization of the column reference in the formula should be the same as the capitalization for the column name you are referencing.  I coppied your formula in the post and as long as my capialization was matched it worked for me. 


    The column alignment does look interesting (do you have the browser zoomed in or out)

  • Steven Stone


    My browser was zoomed in causing the columns and cells not to align.

    Interestingly enough when I zoomed out causing the cells and columns to align the formula worked.

    Thanks for all the help!

  • Travis
    Travis Employee
    edited 06/23/15

    Just a note - if your column header contains a single word, brackets are not necessary. You could type out the formula like this:



This discussion has been closed.