List of all ranges defined for a sheet

Huntb2000
Huntb2000
edited 12/09/19 in Formulas and Functions

Hi Folks,

We have been using a lot of cross sheet links and need to clean things up.

Is there a way to see all the named ranges used to access data in a sheet?  In other words, show all the ranges and thus the sheets, that are using data from the current sheet?

 

Thanks!

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!