In one of our integrations I have a calculated field to combine business and personal emails into in field. The logic works so that if anyone has a blank business email it will pull in personal email, and if anyone doesn't have either it will create a dummy email (userID@fakecompany.com). The calculated field is working as expected, however, I would now like to filter out anyone who has "fakecompany.com" in this new calculated column. Does anyone know how I would go about doing this?
Thanks for reaching out. Calculated filters can be used to achieve such functionality of setting field values from different fields based on conditions. However, calculated fields cannot be used in filtering logic. One way to achieve the desired functionality is to use advanced filters and filter out records that do not have both Business Email and Personal email values. Attaching snapshot for such configuration, we have used custom object to show the behavior.