If you delete a reference, can you get it back?

Options

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

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Options

    @EmilyD

    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.

  • EmilyD
    EmilyD ✭✭✭
    Options

    I was able to fix the issue after posting the question. Thank you for your reply.

    All is well!


    Thanks, Emily

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!