Combine all row comments in one cell in same row?

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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!