Count tasks between today and xdays+today

Dvenegas ✭✭
edited 12/09/19 in Formulas and Functions

I have several different project sheets that contain communication tasks.  I create another sheet to create a count of tasks coming up in the next 7 days (I plan to create a report to pull up to a dashboard).  I am having trouble creating a formula that will count the tasks between today and today +7 days.

This is what I have and it's not working :(   

=COUNTIF({EDM - Communication Schedule Range 3}, <=TODAY(7) >= TODAY())



  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Try something like this...


    =COUNTIFS({EDM - Communication Schedule Range 3}, AND(@cell <= TODAY(7), @cell >= TODAY()))

    Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!

    If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!