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
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!