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

Jonathan Valz

Hi,

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?

Thanks!

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.

Mark Cronk

Hi @Jonathan Valz ,

Your documents column should be a multi-select drop down. Instead of using "" in your join statement use CHAR(10).

Work?

Mark

Jonathan Valz

Hey Mark,

Thanks! That works perfectly. See below the row above is now updated with the formula.

Mark Cronk

Hi @Jonathan Valz ,

Your documents column should be a multi-select drop down. Instead of using "" in your join statement use CHAR(10).

Work?

Mark

Jonathan Valz

Hey Mark,

Thanks! That works perfectly. See below the row above is now updated with the formula.

Mark Cronk

Excellent. Glad you found a solution. Thank you for contributing to the Community.

Mark