How to delete referenced sheet formula

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. 


  • 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.


    *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.




  • 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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!