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
Check out the Formula Handbook template!