Auto Populate cellc based on another sheet for repetitive tasks
Hi There, I want to create a user onboarding and a user offboarding sheet based on a form that we have created for HR to fill in. The form contains the persons name, personel number, who that person reported to ,what role the person has/had and date of employment or termination. Based on what option is selected "Onboarding" or "Offboarding" secondary sheets need to be populated with a list of tasks that need to be ticked off for each of the entries on the HR form. I want to know how I can populate the sheets based on the above mentioned.
Help Article Resources
Check out the Formula Handbook template!