Cross sheet formula help

steve50951 ✭✭
edited 12/09/19 in Formulas and Functions

I have a master property sheet that is updated with new property information. One of the columns in the property information sheet is "Sales Rep." I created another sheet that I want to track the list of properties for each sales rep. 1 sheet is setup for each sales rep. 

I would like for the tracking sheet to pull all of the properties from the master property sheet that have the sales rep name attached. 



Screen Shot 2019-02-22 at 10.35.02 AM.png

Screen Shot 2019-02-22 at 10.35.20 AM.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!