Cross reference error

Hi there

I have created a cross reference with another sheet and named the ranges as well.


It works fine for few days and then after few days it shows invalid ref error

Again i have to re refere the ranges in the formula and it works fine for few days. Please help me and guide, what i have been doing wrong.


Kind Regards

Nitin


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!