Hi Nick! Thank you for suggesting this! This is exactly what I did in the test list formula, so it’s there already. What I am trying to do is to only show the action items shown (in the test list) in a filter view of the action items table. That’s where I’m stumped xD
I guess I’m still confused about what you’re after. You want to filter to just show certain rows in the table labeled focus action items yeah? If Brand Identity is selected in the control, can you list the rows that should show in focus action items for me?
Oh sorry about that! I feel like I’m being very confusing
I’ve done some more testing and it seems like the test list isn’t showing me what I need. But this formula works: thisRow.[projects DB].[all sub action items]
On that page there are two filtered view tables: one for projects and one for action items.
When Brand Identity is selected in the control, the projects table view (Project Focus View) at the top shows the project, it’s sub-projects and all it’s associated action items. It is this list of action items that I want shown in the action items filtered view (Focus Action Items) at the bottom (so 4 items).
At the Brand Identity level in Project Focus View, you’ll see the 4 items listed in the all sub action items column.