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.