Creating a Directory - Need Help with Multiple Sheets


Hi All,

Fairly new to Smartsheets and trying to create a company directory. The goal is to have one sheet with all the employees information. Then to have a second sheet that would pull information from that first sheet and sort it by property. We have people that cover multiple properties so that's where it gets complicated. I created a multiple select drop down to select which properties they cover and a column for their job title. Not I am trying to figure out how to get the second sheet to pull them from the original and enter their name in the column that matches their job title.

I am not opposed to using a Dashboard for this if that is easier but I've never really been able to figure out how those work. Thanks in advance for any help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!