Hello! I am working on multiple projects for a single client, but need them to communicate with each other so no two tasks are assigned to the client at the same time. I understand there is a manual way to create dependencies between sheets/projects, but is there a simpler function I could apply? Something like "If X resource assigned tasks on same date, stagger dates, prioritizing Y sheet" or something to that effect. Does this make sense?
Help Article Resources
Check out the Formula Handbook template!