=If Formula for when "" to output ""
Hello Smartsheet Experts, I am new to Smartsheet and Syntax as a whole. I am in need of some assistance.
I have a formula to change Mod 1 to "Beamline" if "Tool Number" is above 239000 and if below 239000 Mod 1 changes to "90" BUT when there is nothing entered in the tool number column I want the Mod 1 cell to clear if tool number is cleared.
Current Formula: =IF([Tool Number]@row > 239000, "Beamline", "90") This has worked great thus far but my problem is that when nothing is input under tool number the formula then makes the value under "Mod 1" the value below 239000. Thank you!
Best Answer

Solved. For anyone who stumbles upon this and doesn't have a clue like me 20 minutes ago.
What I found is that by restructuring the formula to first check and see if the tool number row 0 and THEN if it isn't blank to see if the tool number is above 239000 or below it. tack on a second if in the formula and its all set.
Fx=IF([Tool Number]@row = 0, "", IF([Tool Number]@row 239000, "Beamline" , "90"))
Answers

Updated formula... no success yet.
=IF([Tool Number]@row = 0, "", =IF([Tool Number]@row > 239000, "Beamline", "90"))

Solved. For anyone who stumbles upon this and doesn't have a clue like me 20 minutes ago.
What I found is that by restructuring the formula to first check and see if the tool number row 0 and THEN if it isn't blank to see if the tool number is above 239000 or below it. tack on a second if in the formula and its all set.
Fx=IF([Tool Number]@row = 0, "", IF([Tool Number]@row 239000, "Beamline" , "90"))

I think you might have a couple problems with your formulas but this should do you. Nested IF statements is what you probably should be looking for.
Mod 1 would have this in as a column formula ...
=IF([Tool Number]@row = "", "", IF([Tool Number]@row <= 239000, "90", IF([Tool Number]@row > 239000, "Beamline")))
Let me know if this does it.
Hope this helps!
Heath Hilton
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!