I have a picklist field(Team__c) at User level with different Team Names in it, which is pulled on to Accounts and Opportunities using a formula field.
So now I need to give access to a user to edit any accounts or opportunities owned by different user if the Team__c equals "Team A".
So I tried to do this using Sharing rules but in the criteria I'm not able to access the formula field to check for the team__c. FYI - In the roles he has edit access to all the records.
How can I achieve this ? I need to give him access to all the records owned by his Team.