I'm looking to join text from several columns with each section of text separated by a carriage return and blank cells skipped. Based on the article below I wrote the following which is unparseable
=JOIN(COLLECT([Join Open-Ended Rating]:[Join Comments7]:[Comments5 Column], ISTEXT(@cell)), CHAR(10))
I can't figure out where it is going wrong - the number of columns or syntax.
Help Article Resources
Check out the Formula Handbook template!