I need help Join/Collecting Rows

Allen Cheung

So I have an issue with Smartsheet formulas where I am unable to write the formula to join rows. So, if the "left_company" Column values are equal, then join/append the "Timeline Date" values so that the output is showed on the "Timeline" Column. Do not populate the "Timeline" Column if there is already one for the same "left_company" value

Paul Newcome

Try this:

=JOIN(COLLECT([Timeline Date]:[Timeline Date], [left_company]:[left_company], @cell = [left_company]@row), "delimiter of choice")

Allen Cheung

Hi Paul!

That worked wonders! Do you think it is possible to not have duplicate entries?

Like if we already have a value for the first 10x Genomics the second wont have a value in the Timeline column?

Paul Newcome

You would need to insert an Auto-number type column with no special formatting (called "Auto" in this example) and then use something like this:

=IF(COUNTIFS(Company:Company, @cell = Company@row, Auto:Auto, @cell<= Auto@row) = 1, JOIN(COLLECT(..........)))