BUG: #NO MATCH returned on X-Sheet Ref

J. Craig Williams

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

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

http://ronin-global.com/2018/02/22/smartsheet-secure-your-sheets-with-x-sheet-references/

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.

Craig

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.

Shaine Greenwood

Hi Craig—

If you're not already, I'd recommend working with our Support team on this so they can effectively troubleshoot the bug and report it to our developers.

It's definitely odd that it works as expected in one browser but not another. I know that different browsers do math/logic parsing differently so I've seen some instances of other formulas and rounding disparity between browsers that our devs had to fix.

J. Craig Williams

I haven't gotten a response from the support team other than the "up to 96 hours" auto-email.

Craig