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.
Answers
-
Hi @Edward Basson
Hope you are fine, you can do that by using the nested If function if you like, please supply a screenshot for the second sheet you need to fill the list of tasks that need to be ticked off for each of the entries ( remove any sensitive data ) and i will help you to do it.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Because the sheet is so wide I took 3 Screenshots. You will notice the line in orange, this is a copy and paste from the HR form. What I would like to see happen is the column's labeled "Description, links, or instructions" be populated every time a new entry occurs in the HR form particularly when the "Onboarding" drop down is selected. Bare in mind there is a "Employee Offboarding" Sheet that will need be populated in a similar manner.
-
I'd recommend using cross-sheet formulas, VLOOKUP, or INDEX/MATCH and manually add the Ticket number sequence to the structure in the other sheet.
Something like.
Main Sheet
Ticket 1
Ticket 2
Ticket 3
Second Sheet
Ticket 1 - Parent (You'd only have to add the Ticket ID to the parent)
Ticket 1 -Child 1
Ticket 1 -Child 2
Ticket 1 -Child 3
Make sense?
Would that work/help?
I hope that helps!
Have a fantastic week & Happy Holidays!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!