Concatenating Contacts List Columns but Omitting One Option

I have two contact list columns that I need to combine into one column. One of the columns however has "Not Applicable" as an option. How do I concatenate both columns but not include any instances of "Not Applicable".

Contact Columns are Program Lead and Internal Speaker (this is the column which contains "Not Applicable" as an option.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!