<div>
<div class="content wysiwyg-content">
Hi all, <br />
<br />
I have a Google Sheet Template for New Hires. It contains basic info for the IT group to create the account. Currently the manager, after filling out the basics, then has to share it to a group that is responsible to complete several task. <br />
<br />
I would like to know how to do the following:<br />
1) Have a cell that when pressed will automatically share it to group.<br />
2) Have a cell that when clicked it will put in &quot;Completed by [tech's email address]&quot;.<br />
3) Have a cell called Task Completed that will send a notification back to Manager notifying him the New Hire task is completed.<br />
<br />
Thanks in advance.
</div>
</div>


Hi all, 

I have a Google Sheet Template for New Hires. It contains basic info for the IT group to create the account. Currently the manager, after filling out the basics, then has to share it to a group that is responsible to complete several task. 

I would like to know how to do the following:
1) Have a cell that when pressed will automatically share it to group.
2) Have a cell that when clicked it will put in "Completed by [tech's email address]".
3) Have a cell called Task Completed that will send a notification back to Manager notifying him the New Hire task is completed.

Thanks in advance.

Basic workflow using Google sheet

Google Workspace is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Workspace adds business-specific features such as custom email addresses at your domain and storage for documents and email.