Custom menu named Activate / Deactivate notifications will be added on the menu bar with 3 actions :

By clicking on authorize email, you allow Google to send you emails

By activating this notification, email notifications will be sent to the task owner and project manager following these conditions :
With this function, there will be no notification emails
Column I has been Protected because it has information on the Mails that is been sent to the manager. Since the request had criteria to send mail to manager on task completing only once, we had to store the data in some place, and yet not to be tampered by the users. As a solution for the above issue, we have given permission only for the owners to make changes to column I. We Hidden this column, so that user will not have the knowledge of this column existence. |