Hi Smartsheet community!
I have a from that our team uses to rank our vendors. The team selects 1st, 2nd, and 3rd place vendors and they have the option to leave comments for each vendor they select. As the results tend to involve the same three vendors, I need to find a way to "automatically" combine the comments into one cell.
As an example, let's say my first place result is Vendor X. I receive 6 votes for vendor X and there are comments associated with each. What kind of formula can I use that does the following: Based on the vendor column, for every matching vendor, combine the comments into one cell. Ideally, there would also be a way to clearly differentiate when a new comment starts (i.e. using a symbol like "]" after they are combined. I'd like it to be formula based so as more responses/results come in, they continually are updated/auto combined.
Screenshot for what I'm looking for as a result. Note that ideally the "Combined Comments" column is where the formula is based.
