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, join the Smartsheet Guru Elite
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, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions

Amazing! Thank you Darren!

@Maria Ba You're welcome!
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 220 Industry Talk
 457 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!