Delete Range Lookups

Cam Swift

Ive reached the 25000 cell limit for the range lookup for the VLOOKUP function.

 

Problem is, Ive forgotten where all the range lookups are across multiple sheets. What we nee to know is where we can find a list of the named ranges. I know that they are a named range because when a range of cells is selected it names them i.e. 'Quote Tracker Range 2'.

Question is where can you find a list of these and delete them.

Cameron

sean59916

Hi Cameron - 

I don't believe this is available to view from the Smartsheet UI. The Smartsheet API appears to provide the ability to list cross-sheet references 

 

Regards, 

 

Sean

Andrée Starå

Hi Cameron,

Unfortunately, Sean is correct, it's not possible at the moment to view a list of the ranges in Smartsheet, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Cam Swift

If that's the case then how does one fix the limitation issue. Without running an API which I cant really be bothered with, I need to fix the range lookups to another sheet which will work for us. Problem is I'm just creating another range although the same process therefore exceeding the limits even further.

 

Cam Swift

And Im also putting it out there that Im getting a bit sick of adding enhancements requests to a software program that should have these functions natively since the feature is there.

I get all of these emails saying things like, apple voice over support on ios, when core functions of the software still suck.