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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!