Formulas and Links to Other Sheets Disappeared


I have a large project sheet that contains (1) cross-sheet links and (2) formulas to calculate due dates based on other tasks.

I needed to change the sheet to only populate weekdays (no weekends) so I turned on the dependencies and edited the workdays.

Then I realized ALL of my cross-sheet links and formulas disappeared!

I have over 3,500 rows that I am going to have to rebuild if I can't get them back. Any advice?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!