# Help with multylook ups/filtering **URL:** \ **Category:** Ask the Community\ **Created:** [October 8, 2025, 1:55pm UTC](https://connect.superhuman.com/t/help-with-multylook-ups-filtering/57718 "2025-10-08T13:55:55Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Goran\_Vasilevski1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/goran_vasilevski1/32/47965_2.png) [@Goran\_Vasilevski1](https://connect.superhuman.com/u/Goran_Vasilevski1)\ **Post date:** [October 8, 2025, 1:55pm UTC](https://connect.superhuman.com/t/help-with-multylook-ups-filtering/57718/1 "2025-10-08T13:55:55Z")
Hi everyone, While I use Coda a lot, i dont think im the expert on formulas and would appreciate anyone’s guidance here. All of the data here is dummy but the idea is the same structure: ![image](https://global.discourse-cdn.com/coda1/original/3X/b/0/b063b22538eb285d132d83e6bdb3ce684b628335.png) I need help with 2 points here: 1. The developer column in Table 2 has a relation done with the above table (Table 1) but I can’t figure out how to do the following: \*Selecting 1 name to add all entries from table 1 under that name (in stead of doing multiselect for all rows in table 1) 2. Sprint column in table 2: this one also is a lookup function from table 1, but I would like to make it a drop down menu where I can select between the sprints. \* Right now i see that the Sprint column is bound by what I select in the developer column. But I want to be able to divide this view example: Alex to have his entry in Sprint 12 the first bracket and then Sprint 13 the middle bracket of grouping. If something is not clear in my question or you need more details, please let me know. Otherwise would appreciate your help here as ive been stuck with this for 2 days and can’t figure it out at all 😀 ---
**Author:** ![anon1959570](https://avatars.discourse-cdn.com/v4/letter/a/eada6e/32.png) [@anon1959570](https://connect.superhuman.com/u/anon1959570)\ **Post date:** [October 8, 2025, 2:29pm UTC](https://connect.superhuman.com/t/help-with-multylook-ups-filtering/57718/2 "2025-10-08T14:29:42Z")
Since you already have dummy data, I suggest you share the doc with the community so we don’t have to recreate solutions from scratch. > [@Guide: How to share your doc with the Coda Community](https://connect.superhuman.com/t/guide-how-to-share-your-doc-with-the-coda-community/47043): > > TL;DR Guide (especially for new Coda-Users): [How to share your doc with the Coda Community](https://coda.io/d/_dGngXuVg7FY/How-to-share-your-doc-with-the-Coda-Community_suKHgWk0). Just copy and paste it into all topics where there is insufficient information. Long version: Hello folks, This is my first post in this category. I don’t think this post has much added value, but I decided to publish it here anyway. In the last months, I have often seen that new users, in particular, need help, but are not aware that it is extremely important for us to share their document, add a… ---
**Author:** ![Goran\_Vasilevski1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/goran_vasilevski1/32/47965_2.png) [@Goran\_Vasilevski1](https://connect.superhuman.com/u/Goran_Vasilevski1)\ **Post date:** [October 8, 2025, 2:32pm UTC](https://connect.superhuman.com/t/help-with-multylook-ups-filtering/57718/3 "2025-10-08T14:32:42Z")
Yea that is not a problem at all 🙂 Here’s the page: \* [Goran's Coda Playground](https://coda.io/@goran-vas/gorans-coda-playground) ---
**Author:** ![Pablo\_DV](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pablo_dv/32/49028_2.png) [@Pablo\_DV](https://connect.superhuman.com/u/Pablo_DV)\ **Post date:** [October 9, 2025, 9:02am UTC](https://connect.superhuman.com/t/help-with-multylook-ups-filtering/57718/4 "2025-10-09T09:02:24Z")
Hi Goran, I think the main issue is your data model, specially the ‘Sprint Tasks’ table. ![image](https://global.discourse-cdn.com/coda1/original/3X/8/8/8875fa8fc691cba78e68376343bf743df9784f37.png) Here you don’t only have tasks, but estimations and worked hours per developer. Those are different business objects and in my opinion they should be split in different tables. Once you’ve done that, it will be much easier to build your summary table. Hope this helps, Pablo ---
**Author:** ![Goran\_Vasilevski1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/goran_vasilevski1/32/47965_2.png) [@Goran\_Vasilevski1](https://connect.superhuman.com/u/Goran_Vasilevski1)\ **Post date:** [October 9, 2025, 9:52am UTC](https://connect.superhuman.com/t/help-with-multylook-ups-filtering/57718/5 "2025-10-09T09:52:44Z")
Thanks Pablo. Acctualy I also figured it out for my first 2 questions that im trying to do relation from a master table in stead of a diferen’t table. As you said, I should be dividning all of this data in multiple tables and ill be able to play around more easily with it. Thanks for the tip. ---
**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\ **Post date:** [October 9, 2026, 9:52am UTC](https://connect.superhuman.com/t/help-with-multylook-ups-filtering/57718/6 "2026-10-09T09:52:49Z")
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.