Hi, i need some help with a formula. Can anyone help?
I am trying to get the weight column to automatically tell total weight based on two bits of information entered in to to coil thickness column and Lineal meters column.
The formula would be based on these principles;
If "coil thickness" is 0.4, then weight would equal "lineal meters" x 3.2, but if "coil thickness" is 0.5, then weight would equal "lineal meters" x 4.2.
Is this formula possible?
Any help would be appreciated. Thanks
Best Answer
-
Hello @Chrisr
Hope you are well. Try this in your Weight column:
=IF([Coil Thickness]@row = 0.5, [Lineal Meters]@row * 4.2, IF([Coil Thickness]@row = 0.4, [Lineal Meters]@row * 3.2))
Peggy
Answers
-
Hello @Chrisr
Hope you are well. Try this in your Weight column:
=IF([Coil Thickness]@row = 0.5, [Lineal Meters]@row * 4.2, IF([Coil Thickness]@row = 0.4, [Lineal Meters]@row * 3.2))
Peggy
-
Dear @Chrisr - please insert the following formula in the Weight column:
=IF([coil thickness]@row=.4, [lineal meters]@row *3.2,IF([coil thickness]@row=.5,[lineal meters]@row *.5,0))
Please make sure you right-click the Weight column and choose the "Convert to Column Formula" as shown below:
Accept my apologies if the above formula fails because my Smartsheet is not working at the moment, so I just wrote it using my knowledge!
Hope this helps!
Please feel free to discuss further if you still face any problem.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 306 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!