IF Statement that returns two values from two different columns

Matthew R

Good Morning Smartsheet Community,

Currently working on a formula that will take the information from "15 single select columns" and condense this information into a single text column. I am trying to reproduce the column titles in my new column as text within the cells.

Previous columns had a single selection for "1" if the issue was present, it would be left blank if no issue was present.

Current formula only produces the first value it finds and does not produce the second value if multiple columns were selected. Not sure how to get it to produce all the values that are present within the row.

Formula: =IF([Pass/Fail]@row = "Passed", " ", IF([Writing on Unit]@row = "1", "Writing on Unit", IF([Missing Parts]@row = "1", "Missing Parts", IF([Sharp Edges]@row = "1", "Sharp Edges", IF([Metal Finish]@row = "1", "Metal Finish", IF([Workmanship Quality]@row = "1", "Workmanship Quality", IF([Back Splash not at 90]@row = "1", "Back Splash not at 90", IF([Front Roll not Straight]@row = "1", "Front Roll not Straight", IF([Material Defects]@row = "1", "Material Defects", IF([Welding Issues]@row = "1", "Welding Issues", IF([Incorrect Parts]@row = "1", "Incorrect Parts", IF(Fitment@row = "1", "Fitment", IF([BOM Error]@row = "1", "BOM Error", IF([Dimensional Accuracy]@row = "1", "Dimensional Accuracy", IF([Engineering Issues]@row = "1", "Engineering Issues", IF([SpecFab Issues]@row = "1", "SpecFab Issues"))))))))))))))))

This formula only displays the first "Writing on Unit" it finds, rather than both a "Writing on Unit" and "Missing Parts" if both are present.

Thank you in advance for any help you could provide!

Paul Newcome

Because you are using a nested IF which stops on the first true value. What you would want instead would be a series of IF statements "added" together.

=IF([1st Column]@row = 1, "1st Column", "") + IF([2nd Column]@row = 1, "2nd Column", "") + ........................................

Paul Newcome

You would include it wherever you have a column name output.

For example:

"1st Column"

would change to

"1st Column "

Paul Newcome

Because you are using a nested IF which stops on the first true value. What you would want instead would be a series of IF statements "added" together.

=IF([1st Column]@row = 1, "1st Column", "") + IF([2nd Column]@row = 1, "2nd Column", "") + ........................................

Matthew R

Works perfectly, did not even consider adding the "+" into it.

My only other small issue is that it is displaying the text lumped together in one long string, instead of separating them with a space in between, is there a way I could structure this formula to accomplish the space between them?

Thank you again for the help Paul!

Paul Newcome

You would include it wherever you have a column name output.

For example:

"1st Column"

would change to

"1st Column "

Matthew R

WOW, it really is that easy for that one HAHA.

THANK YOU AS ALWAYS PAUL!

Paul Newcome

Happy to help. 👍️