Help with multylook ups/filtering

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:

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 :grinning_face:

1 Like

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.

1 Like

Yea that is not a problem at all :slight_smile:

Here’s the page:
* Goran's Coda Playground

1 Like

Hi Goran,

I think the main issue is your data model, specially the ‘Sprint Tasks’ table.

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

1 Like

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.

2 Likes