Need cell to populate with fixed percentage amount of previous cell

Maria Ba

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!

Darren Mullen

@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

@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.

Maria Ba

Amazing! Thank you Darren!

Darren Mullen

@Maria Ba You're welcome!