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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Do you have blanks and/or any non-date values within the range (including rows at the bottom of the sheet)? Tyr this...


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

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!