How can this be connected?

Hi !

I only did one project at a time.:
6680chrome

I need when I select multiple projects to be able to select tasks for ALL of these projects.
6681chrome

How can this be done?

Thank you very much!

Hi @11177 ,

you need to append ListCombine() to List in the List column, as the resulting list has to be flattened first.

2 Likes

Hi @M_Schneider !

Thank you so much for your response!

I did, it seems to work:
6683chrome

But there is an error:

I guess the formula has to be written differently.
Can you give me a hint?

@M_Schneider

And items are displayed as a list (comma separated), not in a circle. Can they be displayed in the same way as projects?

6686chrome

Hi @11177 ,

your syntax is incorrect here, as you’re passing both the filtered table and the whole column as an argument. Use either

 Task.Filter(ProjectTask.Contains(thisTable.Filter(RecordType="Week" ).List1.ListCombine()  ) ).Tasks

or

 Task.Filter(ProjectTask.Contains(ListCombine(thisTable.Filter(RecordType="Week" ).List1)  ) ).Tasks
1 Like

Thats because you specified the tasks names as selectable items, remove the appended “.Tasks” from your formula and the rows itself become selectable.

1 Like

@M_Schneider :clap: :+1: :muscle: Thank you so much for responding!
It all worked out - everything works as it should!

6691chrome

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.