# Issues w/ Switchif in Lookup Item Settings **URL:** \ **Category:** Ask the Community\ **Created:** [March 26, 2021, 2:37pm UTC](https://connect.superhuman.com/t/issues-w-switchif-in-lookup-item-settings/22430 "2021-03-26T14:37:12Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Brittany\_Dufresne](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/brittany_dufresne/32/16830_2.png) [@Brittany\_Dufresne](https://connect.superhuman.com/u/Brittany_Dufresne)\ **Post date:** [March 26, 2021, 2:37pm UTC](https://connect.superhuman.com/t/issues-w-switchif-in-lookup-item-settings/22430/1 "2021-03-26T14:37:12Z")
Hi all, I’m trying to use coda to make a scheduling table, where individual staff have different assignments during the same period. I want to include a catch to make sure I don’t assign the same staff twice during the same period. I’ve been trying to change the item settings on my lookup column (which looks up staff on a separate table) so that if they’ve already been assigned during that period, their name doesn’t show up. However, it only seems to be working for the first argument. For the second argument, all staff still show up even though they have an assignment during that period. Any ideas? Picture for Reference. ![full schedule](https://global.discourse-cdn.com/coda1/original/3X/a/6/a637651325ad9a4299ad78bdec4baca588cbc55c.jpeg) ![full schedule modeh ani selection](https://global.discourse-cdn.com/coda1/original/3X/f/d/fd8f6da546dbad5d253fa951244b0446778d8006.jpeg) ![full schedule beaut.](https://global.discourse-cdn.com/coda1/original/3X/0/1/016f0ad15ae207d99981703233fea0f6c1e7f522.jpeg) ![staff](https://global.discourse-cdn.com/coda1/original/3X/3/b/3bcacfb81160e63f3c48ac7d9a4770de2eaaebac.jpeg) ---
**Author:** ![Christiaan\_Huizer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christiaan_huizer/32/28269_2.png) [@Christiaan\_Huizer](https://connect.superhuman.com/u/Christiaan_Huizer)\ **Post date:** [March 26, 2021, 3:45pm UTC](https://connect.superhuman.com/t/issues-w-switchif-in-lookup-item-settings/22430/2 "2021-03-26T15:45:31Z")
hi welcome @Brittany_Dufresne , I guess this post might be off help to you : [Is it Possible for a select list to be selected only once? - #2 by Johg\_Ananda](https://connect.superhuman.com/t/is-it-possible-for-a-select-list-to-be-selected-only-once/15282/2) You need to open the settings of your lookup and play with Not() and In() Hope it helps, cheers, Christiaan ---
**Author:** ![Brittany\_Dufresne](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/brittany_dufresne/32/16830_2.png) [@Brittany\_Dufresne](https://connect.superhuman.com/u/Brittany_Dufresne)\ **Post date:** [March 29, 2021, 7:10pm UTC](https://connect.superhuman.com/t/issues-w-switchif-in-lookup-item-settings/22430/3 "2021-03-29T19:10:30Z")
Thanks Christiaan - I’ve been playing around with it, but it’s a bit more complicated than the example above. We’ll see how I do though! ---
**Author:** ![Christiaan\_Huizer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christiaan_huizer/32/28269_2.png) [@Christiaan\_Huizer](https://connect.superhuman.com/u/Christiaan_Huizer)\ **Post date:** [March 29, 2021, 7:27pm UTC](https://connect.superhuman.com/t/issues-w-switchif-in-lookup-item-settings/22430/4 "2021-03-29T19:27:38Z")
hi @Brittany_Dufresne , in case you might be able to share a copy of your work with the community, I guess some of us might be able to sort it out with you. best, christiaan ---
**Author:** ![Brittany\_Dufresne](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/brittany_dufresne/32/16830_2.png) [@Brittany\_Dufresne](https://connect.superhuman.com/u/Brittany_Dufresne)\ **Post date:** [March 29, 2021, 8:25pm UTC](https://connect.superhuman.com/t/issues-w-switchif-in-lookup-item-settings/22430/5 "2021-03-29T20:25:23Z")
That would be amazing. Here’s a doc link. [Staff Schedules Trial](https://coda.io/d/Staff-Schedules-Trial_dzdl2ZXkanv) Any insights or suggestions are welcome! ---
**Author:** ![Christiaan\_Huizer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christiaan_huizer/32/28269_2.png) [@Christiaan\_Huizer](https://connect.superhuman.com/u/Christiaan_Huizer)\ **Post date:** [March 30, 2021, 6:20pm UTC](https://connect.superhuman.com/t/issues-w-switchif-in-lookup-item-settings/22430/6 "2021-03-30T18:20:00Z")
hi @Federico_Stefanato , do you have a few minutes to have a look? I guess that what I proposed above is not in line with how the tabels are structured; I am a bit blocked for the moment due to prolonged school holidays (3 weeks instead of 2), cheers, Christiaan ---
**Author:** ![Connor\_McCormick](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@Connor\_McCormick](https://connect.superhuman.com/u/Connor_McCormick)\ **Post date:** [March 31, 2021, 10:13pm UTC](https://connect.superhuman.com/t/issues-w-switchif-in-lookup-item-settings/22430/7 "2021-03-31T22:13:37Z")
Hi Brittany, What you describe is definitely possible, but I don’t think your current schema (the structure of your tables) is the way to do it. I’ll take a crack at coming up with a solution for you, but I want to make sure I understand what you’re looking for. It seems in the doc you sent it already limits the people you can select to those that aren’t yet allocated. Or do you mean that if they are doing Breakfast on Monday they can’t also do Breakfast on Tuesday? If that’s what you meant, you can create a column called [All Days] that has the schedule from all of the days put into one, then your lookup filter can be: ```auto [All Days].Contains(thisRow).Not() ``` I implemented it in the [Tuesday] column for you: ![image](https://global.discourse-cdn.com/coda1/original/3X/8/c/8ca3ca93b8822ffd7dc41dd6303f5335dfc1ed1c.png)