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
-
Hi @Liz Lomax
I hope you're well and safe!
Have a look in the Sheet Reference Manager.
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi @Liz Lomax
I hope you're well and safe!
Have a look in the Sheet Reference Manager.
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks Andre,
This does provide the info I was looking for, but it doesn't seem very user friendly... I cannot see the full name of the range and it doesn't seem to be possible to resize the columns.
The only way to see the full reference name seems to be to select a reference and chose to "edit reference".
But if it's not the reference you wanted, it doesn't seem to be possible to get back to the list, it just kicks you back out to the main sheet, and you have to go in and open the reference manager again, which - if you have a large number of references - makes it really hard to keep track of which ones you've already looked at and which you haven't.
Am I missing something here?
-
Excellent!
Happy to help!
Unfortunately, you're not missing anything, and it's not possible to view it differently, and I agree it's a little cumbersome.
Please submit an Enhancement Request when you have a moment.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!