Is it possible to display tasks from one day?

[Nelly3007]

Hello All,

I may be asking the impossible here but I was wondering if there is a way to pull data from *Today* and display it on another sheet. So I have a master tracker for tasks that need doing and as you can see I have marked the tasks that need doing on that day with an 'X'. Is there a way to automatically display everything from todays date onto a separate sheet so I can see a list of just Todays tasks? Preferably it would also pick up any tasks that may be added later in the year as well.

I cannot add a mini spreadsheet as the app needed to do it is blocked by my company IT but I have attached a screenshot of the tracker and also put a test doc here: Tracker - Test Page.xlsx

Thank you

 

[Fluff]

How about

=FILTER(Tracker!B5:B200,XLOOKUP(A1,Tracker!D4:ME4,Tracker!D5:ME200)="x")

 

[Nelly3007]

How about

=FILTER(Tracker!B5:B200,XLOOKUP(A1,Tracker!D4:ME4,Tracker!D5:ME200)="x")

Hi Fluff,

Yay that's amazing, thanks so much! Just did a bit of testing and adding and it works really well.

Much appreciated, this will make life so much easier! Hope you have a great day.

Many Thanks,

 

[Fluff]

You're welcome & thanks for the feedback.