Totals of column data

Tonya Carmien

Is there anyway to total columns other than using a parent?

 

 

 

 

 

 

Hugh Robinson

See Smartsheet Formula Examples

 

SUM()SUM(cell1,cell2,...) or SUM(range_start:range_end)Adds set of values or range of cells

Tim McCarthy

The smartsheets are similar to excel spreadsheets and many of the same formulas work.

 

Travis

Check out the Help Center article on formulas: http://help.smartsheet.com/customer/en/portal/articles/775363-using-formulas#numeric

 

 

Mat

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.