I need a solution/work around Data Mesh not pulling in Columns with Column formulas
Here is my scenario:
I have my source sheet that collects data from a form. The form is set up dynamically to allow the user to select different options from a multi-select drop down list based on which team they would like to work with.
This creates multiple columns, so to aggregate all of the options selected in to (1) cell I added a helper column in the source sheet that uses a join formula that I set as a column formula.
I want to pull the data from specific columns as well as the aggregated column into the target sheet, however I keep getting an error.
The only solution I can think of is creating a workflow to a helper sheet and using that as the source data for the data mesh since the helper sheet would not carry the formulas.
Is that the appropriate way to manage this?