collecting all comments in one cell?

LMR

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

Paul Newcome

Are you able to provide some screenshots for context?

LMR

hi, yes sorry for not adding it before

This is the workflow that I used that only shows me the last comment:

this is the formula that I have used but that doesn't work:

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

it keeps giving me:

Paul Newcome

The sheet that has the formula in it, does it have a column actually called "Row ID"?

LMR

hi I have added "project ID" to work as the "row ID", but still does not work. Would you mind braking it down on how the formula works? I know it uses 2 different sheets but i am not sure why I can make it work

These are the cell I am using

or if you have a formula that could work

please and thank you