JOIN formula to ignore cells in blank

Hi Trying to get below formula work.

=JOIN(Reedev@row:Yisan@row, Reedev@row:Yisan@row, NOT(ISBLANK(@cell), "| "))

Expected results are on the lat column. Formula above is returning "Incorrect argument set" error. What am I doing wrong. Please help

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!