collecting all comments in one cell?

Hi there,

I am trying to collect all comments in to one cell following these formulas:

=JOIN(COLLECT({Comments}, {Row ID},[RowID]@row))

=JOIN(COLLECT({Comment Only}, {Row ID}, [Row ID]@row), CHAR(10))

Example explaining it:

a way to collect all comments in one cell - Smartsheet.com

however, it keeps giving me #UNPARSEABLE

I also tried following the automation, but it only shows me the last comment, not the whole comment thread.

Could someone please explain how the formula works and what I am doing wrong (also what does CHAR(10) stand for?)

Thank you

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!