Joining cell's with text contents and checkboxes selections onto one text string
We have a design queue sheet where we receive design requests via a web form. Users make a scope selection using a couple of drop down menus and a bunch of check boxes, and an "other" text box for miscellaneous tasks. On the queue side, the number of columns where this information is gathered occupies quite a large area of the view; please see screen shot. it would be great if there was a way to combine the results of these columns into a single cell with a text strings that represents everything selected on the submittal form.
For example I would like the output from the 3rd row to be:
3D Prsentation, Specifications, Populate Floor Plan
And from the 12th row:
3D Sketch, Specifications, no 3d req
If the results could be displayed vertically (with a carriage return) that would be even better.
Thanks in advance for any solution or advice.
Help Article Resources
Check out the Formula Handbook template!