Is there a way to identify what Reports certain Columns are used in?
I have sheet that feeds over a hundred reports - I've identified a column that is a duplicate (one is "All Colors" and one is "Item Colors", but they contain the same data so I only need ONE of the columns). Before I remove one of the columns, I need to make sure all affected reports still contain the 1 correct column I'm choosing to keep - Is there a way to identify where column data is being used? NOTE: I've poked around in Sheet Reference Mgr. and it's useless for what I'm trying to indentify.
Answers
-
The only thing I can really see doing here is adding the "Sheet" reference column to see what sheet the column is coming from, so you can go rename that column. Then all reports that are connected to that column will update with the new column name.
However unfortunately there is currently not a way to identify what reports a sheet is connected to. That is a request in the community pages to have a tab on the side of a sheet that shows what reports the sheet is used in. As far as I know it is not voted up high enough yet to be part of the roadmap.
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
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