Group, Sort, and Filter by Relationship field in Views
in progress
Jake Spirek
Here's a sample use case:
I want to create a list of projects and group them by Client. The Client is a relationship to a task in a list called Clients.
For some reason, I do have the ability to group by some of the linked items, like assignee (in this case I called it "Client Owner").
Log In
Ivan Villa
Hey Everyone!
We've released some new features today. The team is working on documentation updates, but I wanted to share the details here first. 🙂
We added support for Custom Relationships in a few different areas:
- Bulk action toolbar:You're now able to bulk set custom relationships via the relationships option.
- Group by Custom Relationships:This is currently only on list view, but you can check it out and start grouping items by their custom relationships.
- Filter by Custom Relationships:This is available everywhere filtering is, you will now see your custom relationships as items you can filter by.
There is still a lot more we plan to work on. This will be the year of relationships for the team, so we hope to be back soon with some more updates!
Here is a 2-minute clip of me going through some of the features (apologies for the fan noise 😅)
Lukas Moser
Ivan Villa do you have a rough timeline to add this functionality to other views?
Ivan Villa
Lukas Moser Not right now, but we might have some updates soon. I'll be collaborating with other teams to see how we can support relationships across the different areas.
Is there a specific view you're more interested in?
Lukas Moser
Ivan Villa workload would be most beneficial for us
Микита Морозов
Guys, this is an amazing feature and I love it!
Is that panned this to be added to a table view? It could help us a lot: we have some lists with a huge number of items and table view works way better in those cases (it's much more optimized)
Wim Delfs
Would love to see grouping by relationship for board view. Any news here?
A
Andrea Richards
Ivan Villa any update on this? This is also something our teams are looking to have.
Joshua Borger
Ivan Villa Same question. Eagerly awaiting grouping by relationship for board view! As long as organizing columns can be manual--that's a must for us, since we use relationships for linking user stories to epics, then plot those on a user story map.
Ivan Villa
Wim Delfs It is something we are hoping to get to. We had to take a minor break this quarter to shift to another project, but we want to return here and get the rest of these views added.
Joshua Borger
Ivan Villa Thanks for the update! Would love to see board view prioritized among the rest of the views, as it'd help a lot.
C
Chene Brink
There needs to be a "Dependency Type" field containing the type of relationship for example "Blocker" or "Waiting On" that is available in the grouping, sorting, filter & download features.
Joshua Borger
Would love to see grouping by relationship for board view. The reason why is because we use user story maps for the initial planning and design for products, which has the backbone of the product (epics) and then the underlying user stories. If we could group by relationship in board view, I could simulate this process in the board view and make changes a lot easier to implement. Currently we use a whiteboard, but moving objects constantly and updating them aren't the smoothest in whiteboards.
Joshua Borger
To be able to accomplish this, grouping by relationships would need to be able to be manually ordered. So in board view, I could organize the epics in the order I need them from left to right.
A
Abdennour
Awesome first step. It would be really good to have it in the hierarchy, for example on a folder
Uncle King
Allow two layers of grouping in relationships to allow three levels of heirchy in one view like other software by creating a "lookup" feature. Example in Smartsuite. Fast Forward to 2 minute and 55 second mark in the video.
S
Stephanie Zang
Really great first step! Will we also be able to sort, group, filter by RollUp soon as well? This is very important as well
Benjamin Wettlaufer
Hi Ivan. that's already great progress - many thanks! If you now could visualise Relations in a pie chart, then I'm happy!
L
Louis Venter
Yes, very useful indeed. I had to use a workaround to get the filtering and grouping done and had to add the relationship one by one. Thank you for this improvement.
Load More
→