Trying to Count number of items with a date in the next 60 days



I have a sheet that I want to count all of my projects starting in the next 60days. I have used this formula, but it's giving me the wrong answer. I know I have 6 jobs that start in the next 60 days (from today)

=COUNTIFS({Master - Jobs In Progress Anticipated}, @cell >= TODAY(60))

Where's the error? Thank you!

Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!