Is there a way to update referenced sheets using vlookup and/or index and match?
We have an issue where we provision a project from our intake sheet, but after it hits the project roll up sheet, we can't update the status. Here's a summary of how our workflow:
- Intake listing sheet - has our projects intake, which eventually end up as an "approved project". Each initiative has a unique ID which is carried through the lifecycle
- Assessment roll-up sheet - summarizes our initiative assessments
- Project portfolio roll-up sheet - where our projects get listed after its created via control center. We also have some project objects that hold a summary of the project and is adjusted by the team. One item of interest is a project charter object.
What we are looking to do is update the current status on sheet 1, and it subsequently updates sheet 2 and 3. The issue is that when the project is created, sheet 2 changes the status to "Confirmed", breaks any linkages to 1 or 3. Is there a way we can do something like a look up of selected number of sheets with the initiative ID and ensure it all matches back to the current status in sheet 1?
I can provide more details if required.