How do I populate a list of values from one column if a checkbox is selected in another column.

Ideally, I would like to populate all of the values in column 2 into one cell if the checkbox is selected in column 1. I would like each title to be on it's own line in the cell.

For instance, The cell should look like this:

Adjusting to Remote Work Life

Admissions Processing & Review

Advanced Capture (AnyDoc): Administrative Task Cards

Advanced Capture Template Design

Advanced Capture: Configuration Lab - Part 1

Find more posts tagged with

Formulas

Accepted answers

Mark Cronk

Hi @Michelle Carleton ,

Try:

=JOIN(COLLECT([column2]:[column2], [Column1]:[Column1], 1), CHAR(10))

Change Column1 and column2 to your actual column names.

Work?

Mark

All comments

Mark Cronk

Hi @Michelle Carleton ,

Try:

=JOIN(COLLECT([column2]:[column2], [Column1]:[Column1], 1), CHAR(10))

Change Column1 and column2 to your actual column names.

Work?

Mark

Michelle Carleton

Thank you so much. It worked!

Michelle Carleton

How would I do this same formula if I wanted to base the list on two pieces of criteria? Column 3 has one of three values.

Bring back a list if 1.) the checkbox is selected and 2.) the course type is "ILT"

Michelle Carleton

@Mark Cronk

How would I do this same formula if I wanted to base the list on two pieces of criteria? Column 3 has one of three values.

Bring back a list if 1.) the checkbox is selected and 2.) the course type is "ILT"

Mark Cronk

Hi @Michelle Carleton ,

Add another criteria to your collect statement:

=JOIN(COLLECT([column2]:[column2], [Column1]:[Column1], 1, [course type]:[course type], "ILT"), CHAR(10))

Change my range titles to match your column titles.

Mark

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.