function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ross SutherlandRoss Sutherland 

Count Email and then filter

Hello,

I'm using salesforce through Sage People but hoping you can help, I want to do a formula that counts team member records that have the same email address entered by mistake then when the count is greater than 1, filter on it.

Field name is fHCM2__Team_Member__c.fHCM2__Email__c
or might need fHCM2__Team_Member__c.fHCM2__Name_Full__c

I can return a table view with Email and Count but can't filter on it so think I need a row level formula?

Any help would be welcomed.
Thanks

Ross

Anthony FlaggAnthony Flagg
Hello friend, I'm having a similar issue, so I'm commenting to see if someone can help both of us.