SUM formula is not working?

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

Find more posts tagged with

Formulas

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…