Cross sheet formula help
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.
thanks
Comments
-
Have you looked into Reports?
-
Hello,
That is correct, a Report may be best for this desired goal. https://help.smartsheet.com/articles/522214-creating-reports
However, if you desire to utilize a formula you may be able to achieve this utilizing a VLOOKUP. https://help.smartsheet.com/function/vlookup
You may also be able to achieve this utilizing Cell-Linking though it would be more of a manual process. https://help.smartsheet.com/node/2476966
Have a wonderful day,
Eric - Smartsheet Technical Support
Help Article Resources
Categories
Check out the Formula Handbook template!