I have a Control Center program that creates a project management sheet for each new project. In the Intake Sheet we have a contact column "Project Manager" where Control Center pre-populates the project manager's contact name in every row, of the project, where the project manager oversees the task associated with that row, in column titled "Primary Assignee". There are times when, mid-project, we need to reassign a different project manager to the project. Because of the set-up in Control Center, this is easy, as we just update the Project Manager's name in the Intake Sheet column and all the links created by Control Center update the Project Manager's name in the Primary Assignee columns for each of those tasks rows. The challenge: if the row in the project management sheet has a status = Done, I do not want the project manager name to update (to preserve the integrity of the individual who actually completed the work). I have this formula that is 95% complete:
=IF(Stage@row <> "Done", (INDEX({Contact}, MATCH("S1S Project Manager", {Task Name}, 0))),"This is the part I do not know how to right so it retains the previously assigned value rather than updating it.")
The last argument in quotes is the part I cannot figure out how to write so it leaves the previously assigned Primary Assignee value rather than allowing the Index/Match to update the value.
Any ideas on how to accomplish this?
Thanks!
