=If Formula for when "" to output ""

Jacob LeC

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!

Jacob LeC

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"))

Jacob LeC

Updated formula... no success yet.

=IF([Tool Number]@row = 0, "", =IF([Tool Number]@row > 239000, "Beamline", "90"))

Jacob LeC

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"))

Heath Hilton

Jacob LeC,

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.