Formula to fill multi-select from a join of other columns?



See my use case below.

I'm using columns as shown in (1) for users to identify which documents are required per category (rows). I use simple formula columns in (2) to get the appropriate text.

My target is a formula which yields a result as (3).

However, I don't know how to do it and end up with (4) which just concatenates the request.

Is there a clever solution to my problem?


FYI: The use case for the joined Documents column is to provide a simple, singular way for users to filter. The maintenance of this smartsheet will be performed by clicking the checkboxes in (1) which is user-preferred interaction.


Best Answers