I need help adding all of the assets from a column for every row

Brad LeBlanc

I want to calculate my potential assets column for every row I have now and for any I add or subtract. So it adds it up below the last row that has data. I am not good at formulas, I am new to smart sheets and greatly appreciate any help, Thank you.

Paul Newcome

Ok. In that case you would want to put it in a different column or in a Sheet Summary field and use:

=SUM([Potential Assets]:[Potential Assets])

Brad LeBlanc

You are unbelievable it worked dollar sign and comma's. I cannot thank you enough for your help on this,

Have great weekend.

Paul Newcome

Are you able to provide a screenshot with manually entered mock data that shows what you are trying to accomplish?

Brad LeBlanc

mock version of smartsheet.xlsx

Here is a mock version but I have like 25 rows and that could go up and down weekly. So the formula would obviously have to be for all rows in that column. Thank you for your help, let me know if this is what you meant.

Paul Newcome

Where exactly are you wanting this formula?

Brad LeBlanc

Doesn't really matter I just want to see a total somewhere of all of the potential assets. I am not really sure what would work or how to do it. I am not picky first row last row or a separate column what ever is the easiest. Again thank you for your assistance.

Paul Newcome

Ok. In that case you would want to put it in a different column or in a Sheet Summary field and use:

=SUM([Potential Assets]:[Potential Assets])

Brad LeBlanc

Awesome that formula did work in a separate column so thank you. If it is not too much to ask is there a way to add comma's, and a dollar sign to the formula? example the formula you gave me adds it like 7000000 as opposed to $7,000,000 it is not a huge deal but if it is a minor adjustment to the formula it would look cleaner. I am trying to learn how to do the sheet summary field, but this will work fine again thank you so much for your help it is amazing how helpful everyone is in this community.

Paul Newcome

You should be able to click on the three dots on the right of the top toolbar to get additional options and then click on the $.

Brad LeBlanc

You are unbelievable it worked dollar sign and comma's. I cannot thank you enough for your help on this,

Have great weekend.

Paul Newcome

Happy to help. 👍️