I currently have the subtasks (Provisioning, Deployment and ROPE) as separate columns within the main sheet created from a form however it isn't clicking in my head how this would work in this one sheet. Should this be setup in a separate sheet?
I also want to set up a trigger in automation, as an example when Provisioning is checked off as complete, it will alert another person to complete deployment and finally the Rope and so on to the next Request type and their tasks.
I don't want to add separate rows within this main sheet to create the task list, the look of this main sheet should show one line only per new hire.
Please let me know if you need anything more from me. Thank you.