Creating sheet for only assigned individual based on master sheet
Hello,
I have a sheet which contains a combined view of Account Name and their assigned Accountant. The sheet has multiple rows and each Accountant can show up multiple times assigned to different clients.
What is the best formula to use so that I can create individual data sheets for each Accountant that will only pull assigned Accounts to them? I would also like this to be interactive so that if an account is re-assigned it is removed from their specific view.
Thank you
Answers
-
I would suggest creating a report that is filtered by "Current User".
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!