Populating a Formula Multi-Text Field from Summary Fields

Question

Use Case:&nbsp; &nbsp;

I have a "Project" Parent Table with an associated "Intake Worklists" Child Table. The child table is populated with n number of Product Team Records (currently 7 Product Teams) via a pipeline.&nbsp; Each Product Team goes to the child table to self identify if they are impacted by the Project and several other Product Team specific responses related to the Project.
I have summary fields in the table relationship that bring individual Product Team values back to the parent table to indicate each Product Team that is impacted.
I want to be able to populate a single Formula Multi-Select Field with the Product Teams that are impacted.

I have tested that the summary field for each Product Team is bringing back a value of "1" if the Product Team is impacted by the Project.&nbsp; &nbsp;
I am struggling with the formula to populate the formula multi-select (text) field.&nbsp; &nbsp;If and Case conditions do not seem suitable.&nbsp; &nbsp;
Please help?

------------------------------Annetta Coleman------------------------------

markshnier__you · Answer

Try this as a formula multi select field type.&nbsp; It will behave nicely when used as a Dynamic Filter.&nbsp;

Split(ToText([my combined text summary field])

------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

annettacoleman · Answer

Hi Mark -Thanks!&nbsp; Works nicely.&nbsp; Our version of this ended up as follows:Split(List(" ; ",If([# Impacted? (BH)]&gt;0,"Behavioral Health"),If([# Impacted? (Claims)]&gt;0,"Claims"),If([# Impacted? (Clinical)]&gt;0,"Clinical"),If([# Impacted? (Member)]&gt;0,"Member"),If([# Impacted? (Pharmacy)]&gt;0,"Pharmacy"),If([# Impacted? (Provider)]&gt;0,"Provider"),If([# Impacted? &nbsp;(Reporting)]&gt;0,"Reporting")))------------------------------Annetta Coleman------------------------------

Forum Discussion

Populating a Formula Multi-Text Field from Summary Fields