Control Center & Cross-Sheet References

DylBlake

Hello all,

This is my first attempt at SCC provisioning of sheets and I ran into my first problem. There are three sheets in the blueprint -> Sheets A1, A2, & B. B pulls in data from sheet A1 and A2 via cross sheet references (index/match so I can reference by a key value in case rows move around in A1 and/or A2). When I provision the project, the provisioned B is still referencing A1 and A2 sheets in the blueprint folder - not the provisioned A1 and A2 for the project.

Is there a way to have the blueprint manage the references so that the provisioned B sheet references the provisioned A1 & A2? I need the ability to reference by a key value as the rows in A1 and A2 will need to change as people work within them.

Andrée Starå

Hi @DylBlake

I hope you're well and safe!

Yes, but you need to include them in the Blueprint. (go through and add them in the Blueprint builder)

Make sense?

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!