List of all ranges defined for a sheet

Huntb2000

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!

Find more posts tagged with

Formulas

Cell linking

Comments

Andrée Starå

Hi,

Unfortunately, it's not possible at the moment to see a list of the ranges, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Huntb2000

Thanks Andree, Once again you have the answers. Appreciate all you do for the community.

Andrée Starå

Thanks so much for the kind words!

I'm always happy to help!

Have a fantastic weekend!

Paul Newcome

I would love to be able to quickly and easily get a comprehensive list of what is linked where. Until this becomes a feature, I have begun manually tracking my references on each of the source sheets.

It is a little bit of extra work, but it helps me keep everything straight. Since I am listing each reference on the source sheet, I am able to see the list whenever I link to the sheet again which helps with consistent naming conventions and helps avoid having more links than needed.

Andrée Starå

Yes, that would be amazing!

Would make it so much easier when I'm working on different client solutions that aren't always structured the same.

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…