Join text based on multiple conditions

Hello all,

I need to Join the content of a Task column into one main cell in another column "Description".

The conditions are: IF [Task] at row CONTAINS "Action Item" and Summary Field is unchecked than JOIN all the text separated by a comma (or even better assign a number to each of the tasks that contain "Action Item").

My attempted formula:

=IF(AND(CONTAINS("Action", Task@row ), [Summary Field]@row = 0), JOIN(Task:Task, " , "), "")

I cannot share screen shots

Find more posts tagged with

Formulas

Join

Accepted answers

All comments

Corey W.

@Tony Oxa Collect works for me:

=JOIN(COLLECT(Task:Task, Task:Task, CONTAINS("Action", @cell ), [Summary Field]:[Summary Field], "0"), ", ")

Tony Oxa

hello Corey,

Do i nest your part with my IF AND formula or what you provided is the whole formula?

Tony Oxa

Hello Corey,

It worked like a charm thank you so much :D

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.