Reports pulling through duplicates columns
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
Comments
-
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 support@smartsheet.com as this would be very odd.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives