Cross sheet formula help

steve50951 · 02/22/19

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

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

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

Paul Newcome · 02/25/19

Have you looked into Reports?

eric.o · 02/26/19

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

Cross sheet formula help

Comments

Help Article Resources

Categories