COUNTIFS formula with year

Raquel Love
Raquel Love ✭✭✭
edited 12/09/19 in Formulas and Functions

I'm trying to put together a COUNTIFS formula for my Sheet Summary that will count the number of items that are shown as Completed in the status column along with what year they were completed in.  Looking at other discussions, I found this:

=COUNTIFS([NVAP Phase/Status]:[NVAP Phase/Status], "Completed", [NVAP Completed Date]:[NVAP Completed Date], YEAR(@cell) = 2019)

This formula produces an "#INVALID DATA TYPE" error message, which is at least a change from the dreaded "#UNPARSEABLE" that I've been getting so far.

Any help on how to put together a formula that might work here?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!