Control Center Find/Replace to Edit Cross Sheet Reference?

James Tontarski

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!

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.

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.