Calculating the Number of Tickets Opened
Options
Comments
-
Yes. You would use a straightforward COUNTIFS for this...
=COUNTIFS([Date Column]:[Date Column], DATEONLY(@cell) >= TODAY(-7))
This will give you within the past 7 days. If you needed a different date range, you would just have to modify the criteria to reflect that.
-
Hi Paul, Thank you it worked.
-
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!