What else but formula help!
Options
Andrea Prochaska
✭✭✭
I need a formula for my sheet and I am failing. I need a formula that works for the attached screenshot.
Calculates: Qty (LB1) x List Price (LB1) x % (LB 1)
I really should have paid more attention in algebra! :(
Tags:
Comments

Hi,
if you really want to see how many $ 4% are, then use something like this:
=([Qty (LB1]@row*[List Price (LB 1)]@row)*[% (LB 2)]@row
And go to the Smartsheet help center and have a look at the formula help there ;)
Hope this helps.
Projektmanagement Professional in Frankfurt am Main, Germany

This article is also really helpful for learning what each of the formulas do.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!