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?