Calculating a Percentage value of a total value in a column
Hi,
Im a contractor and trying to calculate my contract fee (10%) of the total cost of the build. I have a breakdown of all the costs summed together but cant find a formula to insert in my final cell that would show exactly 10% of the total sum of all the other costs.
Thanks in advance
Best Answer

Hi @Ryan M.
Is the issue that your top Summary row is using a formula to SUM the entire column, which means if you add in your 10% value to that cell it will update your total incorrectly?
If so, what I would do is create the calculation in a different column/cell (such as the one to the left). You'll need to keep it out of this cost column so it doesn't affect that top row.
In the cell to the left, try something like this:
=$[Cost Column]$1 * 0.1
I can't see what your column name is, so in my example I've called it "Cost Column". You'll want to swap this out for your actual column name. Note that I used absolute references (the $ sign) to lock the formula to your top cell in that column. This means if you add rows above or below the current row it will stay locked on that top row.
I would suggest then adding in some text to the Cost Column cell on the right, like "Ten Percent, see the cell to the left".
Cheers,
Genevieve
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions
Answers

I've tired numerous mathematical equations and the only one that works is =5582403.72*.10 which gives me the correct total but doesn't reference [budget1] so it wont auto update as other cell values are changed

Hi @Ryan M.
Is the issue that your top Summary row is using a formula to SUM the entire column, which means if you add in your 10% value to that cell it will update your total incorrectly?
If so, what I would do is create the calculation in a different column/cell (such as the one to the left). You'll need to keep it out of this cost column so it doesn't affect that top row.
In the cell to the left, try something like this:
=$[Cost Column]$1 * 0.1
I can't see what your column name is, so in my example I've called it "Cost Column". You'll want to swap this out for your actual column name. Note that I used absolute references (the $ sign) to lock the formula to your top cell in that column. This means if you add rows above or below the current row it will stay locked on that top row.
I would suggest then adding in some text to the Cost Column cell on the right, like "Ten Percent, see the cell to the left".
Cheers,
Genevieve
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!