Any way to restore cross-sheet references?


I suspect the answer will be what it always is: "no you can't do that but you can submit an enhancement request" but I'm going to ask in the desperate hope I might be wrong...

How can I see what named ranges apply to a sheet? I am attempting to reference another sheet in a countif formula, and when I go to rename the referenced range (don't even get me started on how angry the automatic naming of ranges / inability to see what they refer to makes me), but I keep getting an error that the name I want use has already being used on a range in that sheet.

How can I find out what this other range is?

Is there a name manager?

Can I remove a named range?

How can I select a previously named range to use again?

Thanks in advance and in frustration.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!