Show tasks that are happening today in a report


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
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Fae Katz

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

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • G1NCHY
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!