Show tasks that are happening today in a report

Fae Katz

Hey! So, I'm on a construction company, and I need to make a report that shows the tasks happening today

But I don't know how to show tasks that are not starting or finishing today, but are still in the process of completion.

With these filters, if a task started yesterday and is finishing tomorrow, it will not show on this Report

Thank you for the help!

(The Task column just makes sure it is a task and not a parent row)

Bassam Khalil

Hi @Fae Katz

Hope you are fine, please try the following set of filters.

G1NCHY

Add a new Text / Number column named Tasks Today

Enter this formula - =IF(AND(Start@row <= TODAY(), Finish@row >= TODAY()), 1, 0)

Convert the Column to Formula

Change the Column to type Checkbox

You can create variations on the formula to filter by Today , This Weeks Tasks, Next Weeks Tasks