Formula to fill multi-select from a join of other columns?
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.
Best Answers
-
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
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Hey Mark,
Thanks! That works perfectly. See below the row above is now updated with the formula.
Answers
-
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
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Hey Mark,
Thanks! That works perfectly. See below the row above is now updated with the formula.
-
Excellent. Glad you found a solution. Thank you for contributing to the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.