Help using FILTER

[Paulypaul]

I'd like to add a dashboard tab to my Excel file, which will display filtered data from rows in another tab, dependent upon their date range (start and finish date) values are still valid for this week (e.g. they are still live/have started but not reached the finished date yet).
The purpose of this is to show management a current list of live actions with their corresponding Task name, status, etc. I have highlighted in yellow the columns I wish to display for each Action row.

I've tried referencing two manually-added start and finish dates in my dashboard (e.g. "29/01/2024" & "04/02/2024"), using this formula..
=FILTER(Actions!A:Q,(ROW(Actions!A:Q)=1)+(A1<=Actions!A:A)*(A2>=Actions!B:B))

I know this formula is both incorrect and doesn't select which columns of data I want to display.

Is anyone able to help me? That would be fantastic. Many thanks in advance.

 

[Paulypaul]

The 1,2,5,6,8,9,10,16,17 part is the column numbers to return data from, so you can add/remove those as needed.

I meant can I display only the actions rows for Project 1? (where rows have a tick symbol in column H).

 

[RoryA]

Oh, yes - just add that into the filter: *(Actions!K:K="your tick symbol")

 

[Fluff]

What exactly is in those columns if you look at the formula bar?

 

[Paulypaul]

Oh, yes - just add that into the filter: *(Actions!K:K="your tick symbol")

=FILTER(CHOOSECOLS(Actions!A2:Q1000,1,2,5,6,8,9,10,12,16,17),(C24>=Actions!K2:K1000)*(C25<=Actions!L2:L1000)*(Actions!H:H="✔"))
I tried adding that into the filter (the "✔" marks are in column "H").
I get a "#Value!" error.

 

[RoryA]

Change the last condition to use the same rows as the others, not whole columns

 

[Paulypaul]

Change the last condition to use the same rows as the others, not whole columns

That's amazing. Many thanks for your help.