Referencing Ranges, is there a Range Manager like in Excel?

Eddie Abasta

i referenced a range following the "Reference Another Sheet" option.  But, one of my ranges changed its own name!

It was Called "Carrier"  and adopted another name somehow..

Now i keep getting an error that says the Name is already in use but i can't overwrite it

is there a Range Manager like in Excel?

Andrée Starå

Hi Eddie,

Unfortunately, there isn't at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

You'll have to edit each range one by one.

More info: https://help.smartsheet.com/learning-track/smartsheet-advanced/cross-sheet-formulas

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD