Using IFERROR with a Join Formula

Todd Smelser
Todd Smelser ✭✭✭
edited 07/15/21 in Formulas and Functions

I have a JOIN formula that combines four cells

=JOIN([Add Request Type]@row:[Entitlement]@row, ", ")

I am wondering if I can get help to create an IFERROR formula that would leave a cell in the JOIN Column blank if one of the cells contained in the JOIN criteria is blank.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!