Reference data to pull from another sheet

Options

Dear Smartsheet community,

Can someone please help me to get the correct formula to pull the Emp.Names for each department from Sheet 1 to Sheet 2.



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!