What else but formula help!

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! :-( 

Stefan 7k

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.

Mike Wilday

This article is also really helpful for learning what each of the formulas do. 

• https://help.smartsheet.com/functions