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

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!