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

  • Darren Mullen
    Darren Mullen ✭✭✭✭✭✭
    edited 09/13/23 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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!