Compare Old and Enriched Work Emails in Your Spreadsheet | Clay

Compare Old and Enriched Work Emails in Your Spreadsheet

In my working sheet, I have a column showing old work emails, and I want to compare the enrichment result of work emails compared to the old work email column, to see if the enrichment result truly produced updated work emails. Assuming:

A2:A contains the Old Work Email.
B2:B contains the Enriched Work Email.

I would usually use the formula in google sheet =IF(AND(B2<>"", B2<>A2), "Updated", IF(B2=A2, "Same", "Updated")) to label in a new column whether the emails are updated or the same. How do I do this in clay?

5 comments

Clay
APP
·
·
In Clay, add a new column and select Formula. In the AI Formula Generator, describe your logic: "Compare old work email column with enriched work email column. If enriched email is not empty and different from old email, return 'Updated'. If they're the same, return 'Same'. Otherwise return 'Updated'." Use "/" to reference your columns. Clay supports comparison operators like != (not equal) and == (equal) plus logical operators like AND for complex conditions. Click Generate Formula, review the output, then Save Formula.
Sources: Formulas Comparison operators | Documentation | Clay University Logical operators | Documentation | Clay University
Sabrina I.
·
·
Can you guide me step by step in detail
Clay
APP
·
·
Here's the detailed step-by-step process: Step 1: Add a Formula Column ** Add a new column to your table ** Select Formula as the column type Step 2: Use the AI Formula Generator ** In the AI Formula Generator box, describe your logic in plain English ** Type: "Compare old work email column with enriched work email column. If enriched email is not empty and different from old email, return 'Updated'. If they're the same, return 'Same'. Otherwise return 'Updated'" Step 3: Reference Your Columns ** Use "/" to reference your columns (e.g., /Old Work Email, /Enriched Work Email) Step 4: Generate and Review ** Click Generate Formula ** Review the sample output to ensure it matches your expected logic Step 5: Save ** Click Save Formula to apply it to your table The AI will automatically convert your description into the proper formula syntax with comparison operators like != and == for your email comparison logic.
Source: Formulas
Muhammad S.
·
·
Sabrina I.
Clay
APP
·
·
Here's the detailed step-by-step process for creating your email comparison formula: Step 1: Add a Formula Column ** Add a new column to your table ** Select Formula as the column type Step 2: Use the AI Formula Generator ** In the AI Formula Generator box, describe your logic in plain English ** Type: "If enriched work email is not empty and different from old work email, return 'Updated'. If enriched work email equals old work email, return 'Same'. Otherwise return 'Updated'" Step 3: Reference Your Columns ** Use "/" to reference your columns (e.g., /Old Work Email, /Enriched Work Email) Step 4: Generate and Review ** Click Generate Formula ** Review the sample output to ensure it matches your expected logic Step 5: Save ** Click Save Formula to apply it to your table The AI will automatically convert your description into proper formula syntax using comparison operators like != (not equal) and == (equal) for your email comparison logic.
Sources: Formulas Comparison operators | Documentation | Clay University Comparison operators | Documentation | Clay University