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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!