How to consolidate multiple form responses into a single column?

Tonya Briere

I have a form for each business unit, however, each BU has different response options for like questions. I want to be able to take those "like" questions and consolidate them into one column on the Smartsheet. See mock-up.

Smartsheet Form Response Mockup.xlsx

Paul Newcome

You would use something along the lines of

=JOIN(COLLECT([First Question]@row:[Last Question]@row, [First Question]@row:[Last Question]@row, @cell <> ""), CHAR(10))

Paul Newcome

You would use something along the lines of

=JOIN(COLLECT([First Question]@row:[Last Question]@row, [First Question]@row:[Last Question]@row, @cell <> ""), CHAR(10))

Tonya Briere

@Paul Newcome - this did the trick, thank you for your help!

Paul Newcome

Happy to help. 👍️