Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Is there anyway to total columns other than using a parent?
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.
