Counting cells with certain criteria and within the last year
I have to count how many cells contain a certain value, and have occurred in the last year.
Example: Count of all closed projects within the last year
Project 1 Closed 1/2/23
Project 2 Closed 1/2/21
Project 2 Open 1/2/24
What is the right formula? In excel you can use and count if ( >=date() - 365) or something like that.
Thanks!
Tags:
Answers
-
You could use something along the lines of:
=COUNTIFS(Status:Status, @cell = "Closed", Date:Date, AND(@cell<=TODAY(), @cell>= TODAY(-365)))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!