Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
if statement
Hello,
I am trying to make an "if statement" but I got no luck.
I don't know how to start, I tried with
=IF(sqf1 > "32", "width1*hight1*5.5", "sqf1 < "32""width1*hight1*8.5") I know its looks bad 
Thank you
Comments
-
hi Haithem
you're not too far off.
By using "" you are telling Smartsheet that 32 is text. You also need to consider what you want to happen if your sqft is actually 32 as this would not trigger either condition.
I've assumed you want to multiply by 5.5 if the sq ft is 32 So the final formula is
=IF(sqft1 >= 32, width1 * height1 * 5.5, IF(sqft1 < 32, width1 * height1 * 8.5))
Forgive me but I noticed you'd spelt height as hight so for the formula to work you'll need to change your column header to height
cheers
Mark
-
Thanks a lot Mark! that works with me.
I don't know why I cant give your comment a Like or a reply. Thanks anyway
-
what about this one?
=IF(Type37 = "feet", IF(sqft37 >= 32, width37 * height37 * Qty37 * 5.5, IF(Type37 = "feet", IF(sqft37 < 32, width37 * height37 * Qty37 * 8.5, IF(type37="inches", IF(sqft >=32, width37*height37*qty37*5.5, IF(type37="inches" , IF(sqft37<32, width37*height37*qty37*8.5))))))))
where is the error? I am so confused
-
It might be here:
=IF(Type37 = "feet", IF(sqft37 >= 32, width37 * height37 * Qty37 * 5.5, IF(Type37 = "feet", IF(sqft37 < 32, width37 * height37 * Qty37 * 8.5, IF(type37="inches", IF(sqft37 >=32, width37*height37*qty37*5.5, IF(type37="inches" , IF(sqft37<32, width37*height37*qty37*8.5))))))))
I did not create a test case.
Craig
