=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!

Find more posts tagged with

Accepted answers

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

All comments

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.

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.