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.
SUM
Comments
-
Have you check the capitalization of the column name?
Bryan
-
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.
-
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)
-
Bryan,
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!
-
Just a note - if your column header contains a single word, brackets are not necessary. You could type out the formula like this:
=SUM(Amount:Amount)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives