I can't quite figure out the best way to make this work. Essentially our Payroll team needs to utilize a unique sheet for every biweekly processing. I'm open to any way to make this work. Example picture of the sheet is attached. We have various steps (Description column) that need to be completed, but not necessarily on a specific date. Completed by column: to be filled out by contact completing activity. Completed date: Payroll manager wants this filled out by the contact when step is complete. Deadline: self explanatory. Responsibility: is a contact field that would have a name or two according to which specialty role needs to complete step.
So, I've made this into a template so the Payroll manager can create and archive each pay period step for audit purposes. I have various sheets that utilize automation, but this one I need to almost trigger the next row. So, the checklist is created via template, and the manager will input the date and her contact as creating it. I then need that to trigger an approval or action required of the contact(s) in the next row.
I might be overthinking this, but I can't come up with a solution that makes this simple for the team. A Gantt chart doesn't seem appropriate either. Ideas, thoughts, or comments appreciated!
