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())



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!