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.

Find more posts tagged with

Formulas

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…