BUG: #NO MATCH returned on X-Sheet Ref
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.
Comments
-
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.
-
I haven't gotten a response from the support team other than the "up to 96 hours" auto-email.
Craig
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!