Reports pulling through duplicates columns

edited 12/09/19 in Smartsheet Basics

Hi All , 

We have setup a master project portfolio dashboard (master sheet ) which is fed by multiple sheets (Child )  . The calculation for the dashboard is done via a calculation sheet as shown in the attachment . The on click function in the dashboard opens a report showing high priority projects for instance .

The issue we have is that the report that the on click function opens has duplicate columns . So if we have a column called assigned to that is fed by the child sheets , we have 3x the same assigned to columns appearing in the report 

 Any assistance  would be much appreciated 

Capture 2.JPG

Capture 1.JPG

Capture 3.JPG


  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    You did not show the most important (to me) part -- the Report Builder.

    The typical way to get this result is if the [Assigned To] column is not the same type. To get three of them you'd need some sheets with Contact List type, some with Dropdown List type, and some with Text/Number type.

    some = one or more

    If this is not the case, then I suggest contacting [email protected] as this would be very odd.