When a row is added to your Offboarding sheet, creates the offboarding tasks in Asana, dated from the last day, and emails the manager.
Uses
Asana
Gmail
Google Sheets
Offboard a leaving employee
Leaving checklists get forgotten when they live in someone's head. Add a row to your Offboarding tab with the employee, their manager's email and their last day, and this creates the tasks in Asana: system access removed on the last day, an exit interview 2 working days before it, and a handover task for the manager 5 working days before it.
The manager gets an email with the last day and what has been set up.
leaver.When a row is added to the Offboarding tab. Save it as leaver.leaver.fields.Employee'. Save it as it_task.
Due date: leaver.fields["Last day"]Asanaleaver.fields.Employee'. Save it as exit_task.
Due in working days: -2
Count working days from: leaver.fields["Last day"]Asanaleaver.fields.Employee'. Save it as handover_task.
Due in working days: -5
Count working days from: leaver.fields["Last day"]Asanaleaver.fields["Manager email"]. Save it as told_manager.
Subject: leaver.fields.Employee's offboardingHi,
leaver.fields.Employee's last day is leaver.date_display. We've created the offboarding tasks in Asana, including a handover task assigned to you.
ThanksGmail