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

  • Michelle Choate 2
    Michelle Choate 2 ✭✭✭✭✭✭

    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!