Counts with specific criteria and only those in current year.
Hello, I currently have this formula below but unfortunately its counting all rows with "XY" listed as Supplier when [Dated Closed] column has a closed date in it....because of course I'm telling it to in this formula. But how can I change it to only count those rows with "XY" listed as Supplier and Closed Date, when date is shown are only those in this year (2024) and to not count when Closed Date is blank?
=COUNTIFS({CAPA Supplier}, "XY", {CAPA Helper Column}, 1, {CAPAs Range 1}, <>"")
Answers
-
It would look something like this. I am not clear if one of those ranges is already a closed date range or not, so that would need to be updated
=COUNTIFS({CAPA Supplier}, "XY", {CAPA Helper Column}, 1, {CAPAs Range 1}, <>"", {Date Closed Range}, IFERROR(YEAR(@cell), 0) = 2024
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!