Master sheet auto update from other sheets

ashley.johnson

I’m tracking candidates for summer camp. There are 5 camps and 5 hiring managers. Im using forms to collect the data from the candidates to auto populate on a master sheet. The hiring managers want to work from their own sheets for the interviewing process because 160+ candidates for 5 camps on one sheet is too overwhelming for them. Right now the candidate completes the form, their info auto populates onto the master, an automation based on camp selected copies that candidate to that camp sheet. The hiring manager will then interview, make notes and updates on the candidate from their camp sheet. This process has to be as simple as possible because they don't have time. How can I get their updates to copy to the master without having to link each one?

Andrée Starå

Hi @ashley.johnson

I hope you're well and safe!

• I'd recommend using a Report instead if possible, and it maybe could be to use the Current User feature otherwise, you could create one Report for each hiring manager.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!