If you delete a reference, can you get it back?
Hi,
I am working on metrics and had a reference to a sheet that got deleted by mistake. I thought I could delete the one-column reference without deleting all column references. Not sure what happened. I was able to drag the formula and see the correct data in the onboarding column, but the reference link is not showing on the sheet.
Also, I was wanting to have a formula to pull in whether a check box column is 'not checked'. Tallying the number of tasked without this cell checked.
Thank you, Emily
Answers
-
Did you really delete the reference by going to the Sheet Reference Manager, checking the box next to the reference, and selecting the Delete button? Or did you just delete a reference that was in a formula?
If you deleted a reference in the Sheet Reference Manager, you can only get it back by recreating it the same way you created it the first time which should be quick and easy.
If you deleted it from a formula, you can use the Sheet Reference Manager to see the list of cross-sheet references if you need refreshed on what it was called so you can use it again...or just recreate a new one under a new reference name.
-
I was able to fix the issue after posting the question. Thank you for your reply.
All is well!
Thanks, Emily
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!