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
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!