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
Is there anyway to total columns other than using a parent?
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.
