Need cell to populate with fixed percentage amount of previous cell
Hi all,
I am having trouble doing something so simple, I think I'm making it harder for myself. I have two columns, "Hard Job Cost" and "Commission", as I get a percent of the job as commission. So, if the "Hard Job Cost" is $30,000, my commission is 1.5%. I can't seem to figure out how the "Commission" column shows the HJC x 1.5% = .
I'll also need that reflected for the whole column. I've tried the simple =PERCENTAGE([Hard Job Cost]1, .015) but clearly I'm wrong.
I just started using Smartsheets and while I normally can figure things like this on my own, something is not working in my brain 😖.
Thank you!
Best Answer

@Maria Ba Welcome to the community! There is no "percentage" function in Smartsheet. It looks like are just trying to calculate the dollar amount of your commission?
If so, simply using this formula should do the trick:
=[Hard Job Cost]@row*.015
I used the @row operator so that you can make this a column formula to apply easily to all cells in the column. You can change the formatting of the cells in the column to display as currency as well if you'd like.
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Answers

@Maria Ba Welcome to the community! There is no "percentage" function in Smartsheet. It looks like are just trying to calculate the dollar amount of your commission?
If so, simply using this formula should do the trick:
=[Hard Job Cost]@row*.015
I used the @row operator so that you can make this a column formula to apply easily to all cells in the column. You can change the formatting of the cells in the column to display as currency as well if you'd like.
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions

Amazing! Thank you Darren!

@Maria Ba You're welcome!
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
Check out the Formula Handbook template!