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

Advanced Capture: Configuration Lab - Part 1


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!