Cell Link Breaking when provisioning project in Control Center
I'm trying to create the following workflow and I'm having trouble:
After provisioning a project in Control Center my team goes onto one of the project sheets called "Items Needed" and check off items that need to be purchased. The rows that they check off get copied over to a "Purchasing" sheet. This sheet lives outside of control center so that I don't have to set up the automation for each project provisioned. Once the purchasing department places the order, they put in the date they places the order, when the order arrives etc... onto the "Purchasing" sheet.
I want the "Items needed" sheet to do a Index/Match and pull in the dates the order was placed/received so that while we are working on a project we can see where our items are holding. However, after provisioning a project, the cell links breaks and the Index/Match don't work.
Please note: It's NOT an option to select the items needed on the intake sheet before the project gets provisioned. It's also NOT an option to have a separate "Purchasing" sheet per project as I don't want to be busy setting up the automation for every project that's provisioned.