JOIN COLLECT excluding value on current row.

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), " ● ")))

Find more posts tagged with

Formulas

Accepted answers

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…

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.