Add Columns through Global Update that Contains Formulas with Cross-References?

JuliannaK

I am working on a large update to a project that has 130 toolkits generated through a blueprint. I have to add up to 20 new columns that all would be a column formula containing cross sheet references to another sheet within the toolkits. My question is, if I do this using a global update, would all of the sheets be cross referencing the template sheet, or would the update accurately reference the individual's sheet in their toolkit?

For example: Toolkit template contains two sheets, a Log and an Invoice. I need to add columns to the invoice sheets that cross reference the Logs. When a toolkit is created, everyone gets their own unique Log sheet and Invoice sheet, so when I use global update to add a column and enter the formula like this:

=INDEX({Log | Status}, MATCH([Log ID 1]@row , {Log | Log ID}, 0))

I need to make sure that the update will be looking at the individual's Log's and not the template sheet.

Paul Newcome

If a {Cross Sheet Reference} by that particular name already exists (because it is used in another formula for example), the new formula's {Cross Sheet Reference} will point wherever that particular reference already points from each sheet.

So if the reference exists and is pointing to project specific sheets (not template sheets), then the answer would be that the new formula will also point at the project specific sheets.

HOWEVER… Global Update cannot create new cross sheet references. It will insert the formula, but every output will be the #INVALID REF error because the new {Cross Sheet Reference} has not yet been created.

So if the {Cross Sheet Reference} does not already exist, the answer would be "neither."

After the global update is complete, you will need to go into every sheet affected and create the {Cross Sheet Reference}.