Creates Asana tasks for an exit interview, collecting equipment and removing access when a departure is logged in a sheet.
Uses
Asana
Google Sheets
Offboarding tasks for a departure
Google SheetsWhen a row is added to the spreadsheet. Save it as departure.When a row is added to the spreadsheet. Save it as departure.Task: exit interviewCreate task 'Hold an exit interview with departure.fields.Name'. Save it as exit_interview.
Due in working days: -2
Count working days from: departure.fields["Last day"]AsanaTask: get back the laptop and badgeCreate task 'Collect the laptop and badge from departure.fields.Name'. Save it as return_equipment.
Due date: departure.fields["Last day"]AsanaTask: remove their accessCreate task 'Remove access to company systems for departure.fields.Name'. Save it as remove_access.
Due date: departure.fields["Last day"]Asana