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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives