Ranges

dougwatkins

Hi, I am using "Ranges" when I use vlookup etc, but I don't know how to completely delete a Range (or multiple Ranges)

Does anyone know how to delete all "old" ranges from within smartsheet memory?

I think I need to free-up some resources, I keep getting the error message; "You can only reference 25000 cells" "Please select fewer cells and try again" and I'm assuming that once a very large "lookup-table" is created, it remains using those resources even though it isn't actually used anymore?

Am I correct?

 

 

Andrée Starå

Hi Doug,

You can delete existing cross-sheet references by going to the source sheet, hovering over one of the cells being referenced, and clicking "delete" in the tooltip.

Cross-sheet references are deleted automatically after 2 hours, and unfortunately, there isn't a way to manage the references.

Please submit an Enhancement Request when you have a moment.

Did it help/work?

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

J. Earp

I deleted a range but now all my formulas show invalid reference and when I try to recreate them, it doesn't work. How do I fix this? Thanks!

Genevieve P.

Hi @J. Earp

If you create a new {range} with the exact same name as what you had deleted, this should update all the previously entered references with that name to look at the newly selected column/range.

Cheers!

Genevieve

J. Earp

Thank you!