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.
Totals of column data
Comments
-
See Smartsheet Formula Examples
SUM()SUM(cell1,cell2,...) or SUM(range_start:range_end)Adds set of values or range of cells
-
The smartsheets are similar to excel spreadsheets and many of the same formulas work.
-
Check out the Help Center article on formulas: http://help.smartsheet.com/customer/en/portal/articles/775363-using-formulas#numeric
-
It is not that obvious. On Excel, this is pretty easy to sum an entire column for a sheet that will evoluate along the time.
I want to sum a column in a separate sheet. The reference column length is going to evaoluate along the time (risk manamgement sheet). But you cannot have empty cell in the sum fonction under smartsheet... then I don't know how to mangaged this.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives