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?

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(…………………..