Assistance Needed for Merging Emails in Table Column

Hi, I am having trouble with one of my tables. Specifically, the "Merged Emails (2)" column. I want this column to merge together the valid emails from the merged "Work Email (SMB)" column and the "Validate Email" column which is right after my "Email from ZI" column. Can you help me put in the right first and then statements in the "Merged Emails (2) column to reflect what I want? I can share my table link if that helps.

6 comments

Channeled
APP
·
·
To merge the valid emails from your two columns, you can follow these steps: 1. Click "Add Column" > "Merge columns" 2. Use a formula with conditional logic like this: LBKSIF {{Work Email (SMB)}} exists THEN {{Work Email (SMB)}} ELSE IF {{Validate Email}} exists THEN {{Validate Email}}LBKSThis formula will first check for a valid email in the "Work Email (SMB)" column, and if it doesn't exist, it will use the email from the "Validate Email" column. Make sure to test the formula to ensure it's picking up the data correctly from both columns.
Source: Hide, Re-order, Sort, Filter, Merge Columns
Channeled
APP
·
·
Was that helpful?
Channeled
APP
·
·
Looks like you're still looking for help.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Jake B.
·
·
I mean't I need the proper "First Try" and "Then Try" sections in this "Merged Emails (2)" column. I can't seem to figure out the "Then try"
Bo (.
·
·
Hey - Do you mind sending the link (url) to the table so we can take a look?
(52 kB)
Jake B.
·
·
Hi Bo, I actually just got this fixed with Owen. Thank you!