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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!