Find reports using a particular source data?

Tana Rucker

Is there a way to find all reports that use a particular sheet as source data?  We have one giant sheet that is the mother of all our sheets, and we plan to make substantial changes to it but first want to know what reports are hanging off it.  We want to quickly and easily find all impacted reports and resolve any issues.  

Alejandra

Hi Tana,

We currently don’t have a way to identify all of the Reports pulling data from a specific sheet. When you have a moment, submit a product enhancement request using the form under Quick links on the right to let our Product team know that you'd like to have this functionality in Smartsheet.

In case you find this helpful, I wanted to mention that the Sheet Access Report (available only to System Admins) will also list the names of Reports by licensed users on the account. It would be a manual effort, but you could consider reaching out to the users who own Reports and let them know of the changes that will be made to the master sheet. If needed, more information on the Sheet Access Report can be found in our help article: https://help.smartsheet.com/articles/795920-manage-users-multi-user-plan