How to delete referenced sheet formula

deepak_ar
deepak_ar ✭
edited 12/09/19 in Formulas and Functions

Within a sheet (call it "A") I used a formula referencing a different sheet (let's call it X).

Later I deleted sheet "A". However I see an annoying "Used in formula from unknown sheet" in sheet X. Is there any way I can clear these out?

Please help. 

Tags:
· Share on FacebookShare on Twitter

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Currently, you need to:

    undelete the sheet

    remove all formula references (I just delete all rows)*

    add content to sheet that requires a save.

    wait two hours

    check if the <unknown sheet> reference is gone

    then delete the sheet again.

    Developers are working on a better fix, so I am told.

    Craig

    *kind of defeats the point of having the sheet recoverable for 30 days but ... I hope we won't need to do it this way for very much longer.

     

     

     

    · Share on FacebookShare on Twitter
  • deepak_ar
    deepak_ar ✭

    Thanks. I cannot delete the row.

    Is there a way I can 'delete the reference' to a cell just like 'remove link'. I couldn't find that. Remove link works well but I can't seem to find delete reference.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!