# 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

• ✭✭✭✭✭✭
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

• ✭✭✭✭✭✭
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
• ✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

Happy to help.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!