JOIN COLLECT excluding value on current row.

Sam Swain

Hello all,

I have a working formula but I want to not JOIN COLLECT the value on the current row (@cell)
e.g. in the clashes column, row 3 would just return 'Sub Task 1' and row 4 and 5 would be blank

My formula:

=JOIN(COLLECT([Project Name]:[Project Name], [Person 1]:[Person 1], [Person 1]@row, Start:Start, Start@row >= @cell, Finish:Finish, Finish@row <= @cell), " ● ")))

Paul Newcome

I would insert an auto-number column and then include this in the COLLECT function:

…[Auto-Number]:[Auto-Number], @cell <> [Auto-Number]@row…

Paul Newcome

I would insert an auto-number column and then include this in the COLLECT function:

…[Auto-Number]:[Auto-Number], @cell <> [Auto-Number]@row…

Sam Swain

Worked perfectly. Thanks Paul

Paul Newcome

Happy to help. 👍️