Hopefully, I can explain what I am trying to accomplish…
I have a sheet that is used to create a tab in Glide consisting of multiple List References in Glide. Each column is for one List Reference using the format:
List Reference Name = Sheet : index : multiple
Above, you can see that each column is looking for a unique value in my “Index” column. “Advisors” = “a”, “Partners” = P.
Now, I would like use a form of “contains”, instead of unique values. Meaning, if I have a row where the person is BOTH an “Advisors” (a) AND a “Partner” (b) I would like them to show up in both list references. Currently, they are either (a) OR (b).