How do I set up a workflow to notify line managers of accepted tasks?
I have set up a task request form and sheet. There are several groups in my company who will be accepting these tasks to take on. I'm wondering if there is a way to set up a workflow that will notify the manager of the employee who accepted the task. My first guess is to set up a hidden column in the same sheet with a formula to populate the contact of associated managers and have that cell serve as the person to notify. I'm wondering if there is a more straight forward method? Thanks!