SUM formula is not working?

AircraftLog

I am using form to add row (data) to smartsheet, But newly added row on the top of smartsheet is not included in autosum at the bottom of smartsheet.

How I did it was went to the cell at the bottom I wanted to see SUM and highlited cells from bottom to the top.

 

Rafal 

Andrée Starå

Hi Rafal,

The way Smartsheet works I would recommend that you sum the total on top or point the formula to the whole column.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

AircraftLog

Thank you for your response.

 

I tried to select cell and then use SUM formula and click in the column header to highlights whole column but I am receiving error.

Should I use specific formula?

 

Rafal

 

 

J. Craig Williams

You can't (unfortunately) click the column header.

The format is

=SUM([Column Name]:[Column Name])

the [] are needed if your column name has spaces, special characters, or ends in a number.

You can also try SUMIF or SUMIFS for conditional sums (only sum when certain criteria are met)

Craig

Mike Wilday

Craig's solution works great as long as you aren't trying to sum the entire column in the same column. You will need to put your total in a different column or you will get a circular dependency error.