BUG: #NO MATCH returned on X-Sheet Ref

J. Craig Williams
J. Craig Williams ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I have two sheets, connected to each other via X-Sheet References.

I tested this feature extensively when X-Sheet References came out


Today, I got this behavior

On Main Sheet, I add a Row. I get a #NO MATCH on the return value.

In a different browser, the Secondary Sheet updates correctly.

The Main Sheet has been saved but never indicates in needs to be refreshed. If I do not refresh it or make a change and save it again, the #NO MATCH does not ever* go away.

This does not appear to be a timing issue. If I add the row, save the sheet, refresh the sheet, in the time it takes to move the mouse to refresh it, the sheets update correctly.


ps: Cross Sheet References needs to be added to the Functionality list.

* ever means at least 10 minutes as that's how long I waited.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!