How to list employees based on manager

I have a list of managers and their employees on a data sheet. I then have a template sheet that will be used by the managers to fill in the time spent by each of their employees in a month.

I would like to be able to select a manager on the template sheet and have all of their employees populated in the rows below using formulas. VLOOKUP will only return the first match so that's not too helpful.

Let me know if screenshots would help.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!