Reference sheets talk to eachother?
I am trying to build trackers to update a master sheet, but the master sheet is fed through a form. This is for onboarding employees, so one sheet for offer letter status (only needs name, offer status), another for background check (needs name, background status, etc), another for onboarding documents (needs name, onboarding documents status, etc) and lastly I9 (needs name, I9 status), and as one step is completed they fall to the next step/sheet. So once their offer is accepted, they will fall to background check, once their background check is complete, they will fall to the onboarding documents sheet.
As information is updated on one sheet, it is updated across all sheets.
Please help, TIA!
Answers
-
Is there a reason you don't just have all of the information on a single sheet?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!