How to keep index/match value when source sheet is deleted?


Hi guys!

Is there a way to keep the duplicated value in the new sheet even after the original source sheet is deleted?

I use index/match to match the job order # on sheet A and sheet B, and sheet B has the work hours synced. However, since sheet A is generated every few hours and will be removed, sheet B will no longer have the data. Is there a way to keep the data in sheet B after sheet A is deleted?

Thank you for your help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!