2 Part Questions Re: Reports

Angelique H.
Angelique H. ✭✭✭
edited 06/14/22 in Add Ons and Integrations

Hello,

Is it not possible to data mesh values from a sheet to a Report? If no, then here is my second question:

If I am using 2 sheets to build a report how can I pull information from the second sheet to match to the Primary Column from the first sheet? The Primary columns in both sheets have the same information but the additional columns (build from the second sheet) are not populating - hope that makes sense!

Thanks!

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You would need to create a third sheet that contains the unique identifier on each row and then use two separate datamesh workflows. One to pull from each sheet and populate the respective columns on the third.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You would need to create a third sheet that contains the unique identifier on each row and then use two separate datamesh workflows. One to pull from each sheet and populate the respective columns on the third.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com