Get the Percentage Compared to a Total

Options

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

  • KPH
    KPH ✭✭✭✭✭✭
    edited 12/11/23 Answer ✓
    Options

    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

  • KPH
    KPH ✭✭✭✭✭✭
    edited 12/11/23 Answer ✓
    Options

    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
    Ashley Klaers ✭✭✭✭
    Options

    @KPH

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

  • KPH
    KPH ✭✭✭✭✭✭
    Options

    Happy to help.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!