Counting the number of projects started in a year

I'm trying to count the number of projects starting in a year. I am using the formula mentioned below -

=COUNTIFS({Portfolio Roll-up - Start Date}, YEAR(@cell) = [Primary Column]@row)

where Primary column has the number "2021".

I am getting an error "#INVALID DATA TYPE". Both the columns (Primary and formula column), are text type columns.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!