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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!