Data Mesh. How to pull multiple data points based on multiple selections into one cell
I'm looking into setting up a small process that would allow my team to essentially select multiple choices from a drop down in-order to combine the various results that those selections represent in a separate sheet. The key is that we want to combine those options in a single cell.
Does anyone know if this is possible with data mesh and how to do it? My team was able to make this process work but ONLY if we have a SINGLE selection
To better visualize what we are trying to do please refer to the attached examples.
NOTE: In this example ProjectA Sheet is used only as a sheet that stores references.
In ProjectB Sheet, the user selects what numbers they want from Test Column (1,2,3) and in return they can quickly pull the needed data into the "Data from ProjectA "cell that each number represents for their choices.
Can this be done? or is this a limitation in smartsheets? as mentioned before we were able to make this process work but this process work but ONLY if we have a SINGLE selection.
Looking forward to hearing your recommendations