When status changes in one sheet, how to get it to cross reference into another sheet?
Hello, I am trying to create a workflow when the parts status changes to "ready to schedule" in the Parts Log sheet gets copied into the sheet Project Management. I was able to create this workflow.
The problem I am facing is that every time the status changes it gets duplicated into the Project Management sheet. How do I prevent duplications of rows that have the same WO and just has the cell in the row change?
Help Article Resources
Check out the Formula Handbook template!