List of reports using a column of a sheet
Is there any way to find out the list of reports using a particular column of a sheet?
I want to change the name and column property of a column. However, I would like to know the impact of this change on the multitude of reports that I have created on this sheet.
Is this possible?
Answers
-
Hi @Smtshtuser
No, there currently isn't a way to identify all the Reports that are looking at a specific column in a sheet by identifying the column. You would need to check each of the potential Reports individually to see if they're sourcing data from this sheet and column.
Please provide your feedback on this to the Product team by using this form, here!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
I've written a Python script that uses the Smartsheets API to solve this exact ask. I've modified it for sharing and attached it to this post.
You need to have a Smartsheet API Access Token and also have Python and the smartsheet-python-sdk (v2.105.1) module installed to use the script.
The script asks the user for the name of a column to find and outputs a csv containing a list of Reports and their permalinks to help facilitate navigation. The original purpose of this was to help find which Reports would get broken when a column was renamed or a column's type got changed, and make it easier to repair them.
Note that I am not a professional developer/programmer, so please forgive any inefficiencies or poor practices contained within! As always, review and verify the function of ANY script before running!
-
Thanks Mike for the help.
I will send this to my technical team to would be better qualified to work with the API.
Regards
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives