I have a project table where each project can have dependencies, which are also project (the dependencies column is multi-select lookup that points back to the project table). I’d like to generate a bullet list of projects that are dependencies for each row in the table. typically I would do this w…

I came across this post. Not sure if it’s still relevant for you, but I have figured out a recursive lookup, that makes is possible to make trees/ hierarchical structures. If you’re interested, have a look here: [image] A recursive folder hierarchy - Is this actually working? Calli…

This might set you in the right direction [image] Lists with Levels from Single Table Hierarchies I thought it would be neat to brainstorm some ways to create hierarchal bulleted lists from self referencing data. For instance, a table called Family would have two columns…

Thanks. that did the trick. I’ve been able to build lists of dependencies. Now, I’d like to do something a little different. I want to create a filtered view of the projects such that the view contains the projects that match a criterion(project.team = blah) and those projects’ predecessor projects…

Make a column on each project that lists its predecessors (not bulleted, just like the “Path” column in the example) - maybe you’ve already done this as part of your solution to your first problem. Then your filter formula is something like: project.team = blah OR project.predecessors.filter(curre…

sorry, I wasn’t more clear. I do have the predecessors in a column (from you earlier answer). Now what I want to do is merge the list of projects with team = blah with each of their predecessors. the resulting list will eventually contain projects where team != blah.

Could you share a version of your doc that shows where you want this to display? E.g. is it another column, or a new view of the table with certain filter settings applied?

[image] Nick_HE: project.team = blah OR project.predecessors.filter(currentValue.team = blah).count() > 0 I can’t share the document. I am trying build a filtered view that shows projects (filtered by team) with their predecessors.

actually, I think I have it. I have 2 columns to test: predecessors and successors. Here is a formula that I think captures all possibilities: thisRow.Team.Contains([RTL.Retail Orders]) OR thisRow.Successors.filter(currentValue.Team.Contains([RTL.Retail Orders])).count() > 0 OR thisRow.Predecess…

How can I do a recursive formula?

Nick_HE March 2, 2021, 6:14pm 2

This might set you in the right direction

Topic		Replies	Views
Filter a list based on matching the corresponding info in another column	3	3164	February 20, 2019
A recursive folder hierarchy - Is this actually working? Calling the experts	10	1898	March 9, 2022
Filter( ) doesn't work on a list, retrieved from a related row	4	451	January 12, 2023
Dependency Column	1	706	May 21, 2019
Filter a dependency column based on the value of row	0	79	April 10, 2025

How can I do a recursive formula?

Related topics