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?


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You could enter the aggregate formula into the target sheet and just not worry about trying to pull it over via data mesh. It sounds to me like it probably doesn't need to be matching up to anything specific in a row (different formulas for John and Jane kind of thing) but is more generalized to just pull in what is not blank across a set of columns.

  • Kayla Q
    Kayla Q ✭✭✭✭

    I'm having this trouble too. I can't use a formula because this is a hefty sheet, and formulas take up valuable row count. In the end, I need a way to make data mesh work with trailing zeroes. For example, my primary key might be 5497125.21640. Any advice @Paul Newcome

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @Kayla Q Are you able to adjust the source data before data mesh grabs it? Or are you saying that both the source and the target are unable to use formulas due to size?