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
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives