# Multiple criteria for list reference menu

**URL:** <https://community.glideapps.com/t/multiple-criteria-for-list-reference-menu/1220>\
**Category:** Ask for Help\
**Created:** [October 16, 2019, 9:15pm UTC](https://community.glideapps.com/t/multiple-criteria-for-list-reference-menu/1220 "2019-10-16T21:15:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mptpro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mptpro/32/634_2.png) [@mptpro](https://community.glideapps.com/u/mptpro)\
**Post date:** [October 16, 2019, 9:15pm UTC](https://community.glideapps.com/t/multiple-criteria-for-list-reference-menu/1220/1 "2019-10-16T21:15:05Z")

</div>

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

 ![04](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/31c57cf30e7c598a75cd344c3652057925342770.png)

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).

---

<div class="post-metadata">

**Author:** ![Todd57](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd57/32/600_2.png) [@Todd57](https://community.glideapps.com/u/Todd57)\
**Post date:** [October 16, 2019, 9:30pm UTC](https://community.glideapps.com/t/multiple-criteria-for-list-reference-menu/1220/2 "2019-10-16T21:30:20Z")

</div>

Maybe something like this would work for you.

---

<div class="post-metadata">

**Author:** ![mptpro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mptpro/32/634_2.png) [@mptpro](https://community.glideapps.com/u/mptpro)\
**Post date:** [October 16, 2019, 9:48pm UTC](https://community.glideapps.com/t/multiple-criteria-for-list-reference-menu/1220/3 "2019-10-16T21:48:26Z")

</div>

Yes this helps. I wanted to avoid using multiple columns, but this does work.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 16, 2019, 9:48pm UTC](https://community.glideapps.com/t/multiple-criteria-for-list-reference-menu/1220/4 "2019-10-16T21:48:41Z")

</div>

Yes, what @Todd57 said. I just figured this out myself the other day. Create multiple Index columns in your advisors sheet (Index 1, Index 2, Index 3). That should be all you need to do.

---

<div class="post-metadata">

**Author:** ![Bhupendra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bhupendra/32/788_2.png) [@Bhupendra](https://community.glideapps.com/u/Bhupendra)\
**Post date:** [October 18, 2019, 8:59am UTC](https://community.glideapps.com/t/multiple-criteria-for-list-reference-menu/1220/5 "2019-10-18T08:59:56Z")

</div>

Hi  
I want to help something same…  
I Have Tree Tabs 1. Invigilators Details 2. Exam Scheduled 3. Duty for Exam  
I already create Date wise invigilator list.  
But I stuck at to create invigilator wise duty list.  
Any idea???