Chaining together IF statements

JoshOsborn

I would like to know if it is possible to chain together if statements using the & symbol, similar to Excel.

e.g. =IF(Brand@row="","",Brand@row&" ")&IF(Model@row="","",Model@row&" ")

I have used this method in Excel, but this doesn't work in Smartsheet. Is there a way to make this work?

Find more posts tagged with

Accepted answers

All comments

Melissa Yamada

Hello @JoshOsborn

You can do it by nesting IF statements to perform multiple logical evaluations. :

=IF(Brand@row="","",IF(Model@row="",""))

https://help.smartsheet.com/function/if

JoshOsborn

Thank you for your reply @Melissa Yamada, unfortunately, this won't work in this instance as I need to check and then display certain cells depending on whether or not they have a value in them, and separate dividers depending on which cells contain information.

Paul Newcome

You use the plus symbol to string things together in Smartsheet..

=IF("this" = "this", "output", "") + " " + IF("that" = "that", "another output", "") + " " + IF(…………………..

Brian McElligott

Hi Paul,

I am stringing a series of IF statements, to create a list, but I am coming across a strange issue. Before I get to the field that will be true, there is a "0" appearing in the output of the formula.

Here is my formula:

IF(CONTAINS("CYP", [Approved Event Space]@row ), "Cypress Creek Campus" + CHAR(10)) + IF(CONTAINS("EVC", [Approved Event Space]@row ), "Eastview Campus" + CHAR(10)) + IF(CONTAINS("EGN", [Approved Event Space]@row ), "Elgin Campus" + CHAR(10)) + IF(CONTAINS("HYS", [Approved Event Space]@row ), "Hays Campus" + CHAR(10)) + IF(CONTAINS("HBC", [Approved Event Space]@row ), "Highland Business Center Campus" + CHAR(10)) + IF(CONTAINS("HLC", [Approved Event Space]@row ), "Highland Campus" + CHAR(10)) + IF(CONTAINS("NRG", [Approved Event Space]@row ), "Northridge Campus" + CHAR(10)) + IF(CONTAINS("RGC", [Approved Event Space]@row ), "Rio Grande Campus" + CHAR(10)) + IF(CONTAINS("RVS", [Approved Event Space]@row ), "Riverside Campus" + CHAR(10)) + IF(CONTAINS("SGC", [Approved Event Space]@row ), "San Gabriel Campus" + CHAR(10)) + IF(CONTAINS("SVC", [Approved Event Space]@row ), "Service Center Campus" + CHAR(10)) + IF(CONTAINS("LHC", [Approved Event Space]@row ), "Lockhart Campus" + CHAR(10)) + IF(CONTAINS("RRC", [Approved Event Space]@row ), "Round Rock Campus" + CHAR(10)) + IF(CONTAINS("SAC", [Approved Event Space]@row ), "South Austin Campus")

Here is the odd result:

"0Highland Campus"

I have checked the syntax, but I am missing something.

Thoughts?

Paul Newcome

You need a blank "output if false" in each of the IF statements.

=IF(this is true, do this + CHAR(10), "") + IF(this is true, do this + CHAR(10), "") + ...

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.