Get the Percentage Compared to a Total
I know I'm overthinking this but I haven't worked much with %'s quite yet in SmartSheet.
I'm basically just needed to get a percentage of how much Soft Costs and Hard Costs take from the total budget
So I have the [Construction Loan Amount] column which is my total overall. I need to take the [Soft Cost $$] and [Hard Cost $$] column totals and calculate how much those two totals take up from the main total in terms of percentage.
Ex:
Best Answer
-
What do you mean by "main total" or "total budget"?
Is it the "construction loan amount"/"total overall"?
- So in the example, $10,000 of the $40,000 is 25% and $20,000 is 50%
- If so, the formula is =[Soft Cost $$]/[Construction Loan Amount $]
- Then set the column as a %
- Repeat for Hard Cost just changing the column name
Or do you mean how the soft/hard costs are related to just each other?
- So in the example, $10,000 of the $30,000 is 33% and $20,000 is 66%.
- If so, the formula is =[Soft Cost $$]/([Soft Cost $$]+[Hard Cost $$])
- Then set the column as a %
- Repeat for Hard Cost just changing the first column name
Answers
-
What do you mean by "main total" or "total budget"?
Is it the "construction loan amount"/"total overall"?
- So in the example, $10,000 of the $40,000 is 25% and $20,000 is 50%
- If so, the formula is =[Soft Cost $$]/[Construction Loan Amount $]
- Then set the column as a %
- Repeat for Hard Cost just changing the column name
Or do you mean how the soft/hard costs are related to just each other?
- So in the example, $10,000 of the $30,000 is 33% and $20,000 is 66%.
- If so, the formula is =[Soft Cost $$]/([Soft Cost $$]+[Hard Cost $$])
- Then set the column as a %
- Repeat for Hard Cost just changing the first column name
-
Your first example was the correct one. I slapped that formula in and that seemed to do the trick so much appreciated! :)
-
Happy to help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!