What formulas would determine active proof, current task, and next task?
In my sheet summary, I would like to indicate 1) which proof is currently active, 2) the task that currently needs completed, and 3) the next task to complete once the current task is completed. *Note - The tasks to be referenced will be one of Staff Submissions (children not needed), Consolidate Submissions, Send Proof to PPM, or PPM Return Proof to CSD.
Any help you can provide is greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!