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
-
Are you able to provide some screenshots for context?
-
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:
-
The sheet that has the formula in it, does it have a column actually called "Row ID"?
-
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 usingor if you have a formula that could work
please and thank you
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!