Invalid Reference issue

Options

I have a sheet where I am pulling data from 3 different sheets into. After a while (eg. if im coming back on to smartsheet) #Invalid ref error appears in all my cells. How do i resolve this without having to edit the formula and relinking the sheets?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!