Formula to select multiple options in multiselect column based on multiple checkbox fields

1

I am developing a quality control checklist using a master list of all the QC tasks for our projects that we generally check one or two times through the course of each project. In order to simplify the creation of the master list and which items should be checked when, I created (5) checkbox columns, one for each possible stage to be reviewed. I am trying to automatically select the corresponding review stage(s) from a multiselect field that will allow me to filter the QC tasks depending on which stage of the project I’m in. Below is a snapshot to give you an idea of the table I am working on.

Ideally I am hoping to come up with a formula that looks across the row and if the Job Start QC field is true, it would select Job Start QC in the QC Stages field, then continue checking the other (4) columns, and if another is true, it would ADD that selection to the QC Stages selections.

Bonus points if you know of a formula that can convert the column title to a string.

image

2

Hi @John_Schwarz,

can you share your doc or create a dummy doc and share that?
That would help a lot.

Thanks in advance.

Best regards
Jannis

3

Here’s a link to the page.

4

I just figured it out.
You can use the ListCombine function below. I’m going to unshare the doc, but leave this up in case others run into the same issue.

ListCombine(
SwitchIf(thisRow.[Job Start QC],“Job Start QC”,“”),
SwitchIf(thisRow.[v1 QC],“v1 QC”,“”),
SwitchIf(thisRow.[v2 QC Part I],“v2 QC Part I”,“”),
SwitchIf(thisRow.[v2 QC Part II],“v2 QC Part II”,“”),
SwitchIf(thisRow.[vF QC],“vF QC”,“”)
).Filter(CurrentValue!=“” )

3 Likes