Reference data to pull from another sheet


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!