Need cell to populate with fixed percentage amount of previous cell
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 😖.
Help Article Resources
Check out the Formula Handbook template!