COUNTIF & IFERROR Formulas

Options

Hey all!

I'm getting a data discrepancy when I'm trying to count all of the In Progress requests that we've received in a year. The formula that I'm using is this: =COUNTIFS({Created}, IFERROR(YEAR(@cell), 0) = 2022, {Crew Support Status}, "In Progress")


The Created Column uses a formula that pulls the YEAR from the Created Date column in a sheet. My formula above generates the value of 115, but when I filter the sheet to show the same thing, I get a value of 117. I can't figure out what I'm doing wrong here, so any additional help would be greatly appreciated.

Best Answer

  • sharkasits
    sharkasits ✭✭✭✭✭
    Answer ✓
    Options

    @JKP0009 It's hard to tell without a sample of the data, but what I would do to trouble shoot is add a test checkbox column and put this formula in.

    =IF(AND(IFERROR(YEAR([Created]@row), 0) = 2022, [Crew Support Status] = "In Progress"),1,0)

    Then filter how you were and add a filter for where the test column is unchecked. That should help identify which rows aren't getting counted.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!