Combine all row comments in one cell in same row?

Ripj

I am needing to create a cell that has all of the comments for a particular row combined. We need to display more than just the latest comment. I understand that there is a 4000 character limit for a cell. It would be nice if it showed the latest 4000 characters or we can add a second row/ cell for overflow. I found a post that referenced a workflow using a second sheet but trying to stream line this for multiple sheets. Any help is appreciated.

Andrée Starå

https://community.smartsheet.com/discussion/109328/combine-all-row-comments-in-one-cell-in-same-row

Hi,

I hope you're well and safe!

The second sheet option is probably the best one. You could have all sheets copied to it as long as you have something unique we can use to collect the correct comments back to the correct sheet.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Ripj

By something unique to connect the comment back to the correct sheet are you referring to the sheet name? For these sheets, that is the only unique identifier.

Andrée Starå

https://community.smartsheet.com/discussion/comment/392095#Comment_392095

Yes, we could use that, but then you would need to add a so-called helper column. Another option, and the one I usually use, is to add an Auto-number column.

Would any of those options work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Ripj

I believe so. I will give that a shot and report back. Thank you so much for your help.

Have a great day

Andrée Starå

https://community.smartsheet.com/discussion/comment/392130#Comment_392130

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!