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

Michelle Carleton

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 Template Design

Advanced Capture: Configuration Lab - Part 1

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

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