Get the Percentage Compared to a Total

Ashley Klaers

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:

KPH

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

KPH

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

Ashley Klaers

@KPH

Your first example was the correct one. I slapped that formula in and that seemed to do the trick so much appreciated! :)

KPH

Happy to help.