Sign in to join the conversation:
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! :-(
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.
This article is also really helpful for learning what each of the formulas do.
I am looking for a formula that will look at this table and pull the hours per week based on 2 criteria – group and week. Right now, I have the tables separated so that I can use a vlookup formula. But that means I have to have 5 different formulas, 1 for each group. =IFERROR(VLOOKUP(ROUND(($[First Receive]@row - $[Week 1…
Hi, I am needing to create a column that will display the correct month based off a date in another column. My columns are below. I am not certain on which formula to use. Thanks for the assistance!
My spreadsheet has 4 columns are updated each Month with Stable, Improving, Developing, and Negative. Negative is the highest priortiy, then Developing, then Improving. Please assist with a IF statement, that would look at all 4 columns an update the cell with the highest priority word.example 3 stables and a developing…
