Creating sheet for only assigned individual based on master sheet


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!