Show tasks that are happening today in a report

Fae Katz
Fae Katz ✭✭
in Formulas and Functions

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)

image.png


Tags:
· Share on FacebookShare on Twitter

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Fae Katz

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

    1.jpg


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ 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"

    · Share on FacebookShare on Twitter
  • 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

    image.png


    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!