Cross Sheet Formulas within blueprint - Control Center

01/12/22
Accepted

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?

Best Answer

  • Answer ✓

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

Answers

  • Paul NewcomePaul 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?

    thinkspi.com

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

  • Paul NewcomePaul 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.

    thinkspi.com

  • 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.

  • Answer ✓

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

Sign In or Register to comment.