Cross Sheet Formulas within blueprint - Control Center

Matt Stewart

I am trying to leverage index/match across various sheets within my blueprint. This is faster/easier to maintain, but after creating a project or two the references still point back to my blueprint and not the new versions of the projects.

do cross sheet references not update dynamically to the new projects? or are they static like the move/copy rows automations?

Matt Stewart

must have been a bug with the sheet. i deleted the columns and readded new columns and everything worked.

Paul Newcome

I have used plenty of cross sheet references in blueprints with no issue. Are all of the sheets referenced being duplicated when provisioning a new project?

Matt Stewart

@Paul Newcome ... yes, all the sheets were duplicated but for some reason one of the sheets was not pulling in the data.

Paul Newcome

That's odd. I have never had a problem with it before. You may need to reach out to support if it continues as it sounds like a bit of a bug.

Matt Stewart

ok, even odder...

now im finding that the same sheet, even after changing to inbound cell links, is not pulling the dates over as dates. all other sheets have no issues with this, only this sheet itself. The source data is a date column (which is a formula to calculate when something is due).

this then is pulled into another sheet via inbound cell link (or index/match). the destination sheet is also a date column but it is not sorting like a date and no date info is shown when hovering over date.

Matt Stewart

must have been a bug with the sheet. i deleted the columns and readded new columns and everything worked.