Auto-Populating Field Based On Multiple Selections

Benjamin O'Leary

So something like this?

=JOIN(COLLECT([PCQT Lead Contact Reference List Range 1]), "; ") + IF([PCQT Lead Contact Reference List Range 1]@row <> "", "; ", "") +

JOIN(COLLECT([PCQT Lead Contact Reference List Range 2]), "; ") + IF([PCQT Lead Contact Reference List Range 2]@row <> "", "; ", "") +

JOIN(COLLECT([Automation (Corelab)]), "; ") + IF([Automation (Corelab)]@row <> "", "; ", "")

Paul Newcome

Right. So you use the JOIN/COLLECT on the first multi-select. Then you say that if the first multi-select is not blank, insert the "; " after the first JOIN/COLLECT. Then you proceed with the second JOIN/COLLECT then add the "; " at the end of that if the second one isn't blank. So on and so forth. Just give it a try with the first few to see the output. If it works then you can finish it out with the rest of the multi-selects.

Benjamin O'Leary

I tried the formula I sent you that you said was right and I got an #UNPARSEABLE error

Paul Newcome

You and I were typing at the same time. I actually didn't see your latest formula until after I had submitted my response. You will still need to use the correct syntax for the JOIN/COLLECT pieces.

Benjamin O'Leary

I'm sorry, I don't understand. I need to combine what I have set up earlier with IF statements?

Benjamin O'Leary

@Paul Newcome please ignore my last two messages; they were under review and were added incorrectly to the thread.

Genevieve P.

Hi @Benjamin O'Leary - I've removed them for you 🙂

Paul Newcome

No worries. SO where are we? Do you have it working, or is there still an issue?

Benjamin O'Leary

@Genevieve P. Thank You.

@Paul Newcome I still can't get the formula to work. Even if I remove the ; symbols none of the contact emails appear.

Benjamin O'Leary

I managed to get it to work:

=JOIN(COLLECT({PCQT Lead Contact Reference List Range 1}, {PCQT Lead Contact Reference List Range 2}, HAS([Automation (Corelab)]@row, @cell)), ", ") + ", " + JOIN(COLLECT({PCQT Lead Contact Reference List Range 1}, {PCQT Lead Contact Reference List Range 2}, HAS([Coagulation, Hematology, Urinanalysis (Corelab)]@row, @cell)), ", ")

Thank you for all your help.