Cross Sheet Reference stopped working

We currently have a Pharmacy Site API reference sheet that is updated daily at 2am PT. Since its a complete rewrite, the sheet is deleted then generated every morning with the new updated site information. This master sheet is indexed across several hundred Smartsheet solutions within our company.

I have a specific sheet that has worked for the last 2 years up until 2 weeks ago.
I can see in sheet activity the cross sheet reference cell links are deleted, but the cell link updates are not done until I open the sheet and save or if an update request comes in after 2am.
No changes to our API.
POS New Site Tracker = 21 Total Range References, no reference errors

Column formulas:

=IFERROR(INDEX({Pharmacy Site Information Region}, MATCH([Site #]@row, {Pharmacy Site #}, 0)), "")

(with variations of column names)

Not at any max limits for the sheet, blanks in the IFERROR formula accounts for some sites or assets not yet assigned.
I have rebuilt the sheet entirely from scratch and no broken references are listed.

Find more posts tagged with

Sheets

API and Developers

Formulas

Cell linking

Accepted answers

Dina K.

Good Morning, as it turns out whatever was in the release this week fixed the bug, although nothing was in the release notes to indicate why. thank you for you note @Genevieve P. I will be keeping a close eye on them too :)

All comments

Genevieve P.

Hi @Dina K.

If there's a change in behaviour for something that used to work for you but suddenly no longer does, this type of issue is better reviewed with Smartsheet Support directly. They'll be able to troubleshoot with you in a private channel so you can share a screen recording, sheet URLs, and more detailed information.

Thank you!
Genevieve

Dina K.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.