Countif specific type and year

=COUNTIFS(Type:Type, ="CTA New"), ([Date Submitted]:[Date Submitted], IFERROR(YEAR(@cell), 0) = 2022)

I've been looking at examples of this question all day - but for some reason I can't make my formula work.

The above formula is #Unparseable.

I want to count the number of rows with "CTA New" Type and 2022 Date Submitted Year.

Can you tell me where I'm going wrong with my formula? Do I need an AND function?

Thank you!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!