Multiple cross references for one sheet?


Hi, here's the situation. Sheet A is a master list of employees with their title, supervisor etc. Sheet B has a column that is set up as a dropdown list of names of said employees. When I choose an employee on Sheet B I have it cross reference with Sheet A to pull the supervisor and some other information to fill in corresponding fields on Sheet B. This currently requires me to manually update the dropdown list of employees on Sheet B. Is there anyway to make it so that if I update the master list on Sheet A it will automatically also update the list of available employees on Sheet B and still pull the supervisor etc like it is currently set up to do? The column on Sheet B does not need to be dropdown if a different option will provide the result I'm looking for.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!