Control Center Find/Replace to Edit Cross Sheet Reference?

Hello all,

I was asked to delete a specific column in the CRAID Log template and all instances created through Control Center.

In my Blueprint, I have a sheet that is used to store some meta data that feeds a larger 'master data' sheet. Unbeknownst to me, that column was referenced in a formula on the meta data sheet. Is there a way to update the formula and update the Cross Sheet References using Control Center?

For example, here is the current formula:

=COUNTIFS({RAID Log Range 1}, 1, {RAID Log Range 3}, <>"Completed")

I want to update the RAID Log Range 1 to refer to a different column.

Thanks!

Find more posts tagged with

Formulas

Control Center

Accepted answers

AravindGP

Hi James,

Unfortunately, at the moment, Global Updates in Control Center doesn't support updating/modifying formulas with cross sheet references. You will need to open each individual sheet to update the reference.

All comments

AravindGP

Hi James,

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.