Form entries in one column

Kevin Turcotte

I designed a smartsheet with a form that different departments use to enter information. I built logic on the form- depending which department the user selects, a different employee name drop-down list shows up on the form. I want to have all of the employee names selected enter on one column to avoid blank cells and keep it clean, rather then have blank cells in the un-selected department's column. Is this possible?

Paul Newcome

You could use a JOIN/COLLECT to pull the names from the filled out columns and then hide the specific columns leaving only the JOIN column visible.

=JOIN(COLLECT([Employee Name-Warehouse]@row:[Employee Name-Transportation]@row, [Employee Name-Warehouse]@row:[Employee Name-Transportation]@row, <> ""), ", ")