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
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives