Control Center Find/Replace to Edit Cross Sheet Reference?

James Tontarski
James Tontarski ✭✭✭
edited 07/11/23 in Add Ons and Integrations

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!

Best Answer

  • AravindGP
    AravindGP ✭✭✭✭✭
    Answer ✓

    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.

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

Answers

  • AravindGP
    AravindGP ✭✭✭✭✭
    Answer ✓

    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.

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training