CountIFS with date.

Options

Hi All,

Need help in below formula as am trying to get project list from year 2024 to date. No error but not giving me the correct results.

=COUNTIFS({Completed Range 1}, $Label@row, {Completed Range 2}, "NPD$1", {Completed Range 3}, YEAR(@cell) >= 2024)

Thanks in advance.

Tags:

Best Answer

  • Gia Thinh
    Gia Thinh ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Saj

    COUNTIFS returns a specific counting number, not a list.

    You may want to try COLLECT function that return a list/range and is used within another function. For example, try this one:

    =JOIN(COLLECT({Your Project List Range}, {Completed Range 1}, $Label@row, {Completed Range 2}, "NPD$1", {Completed Range 3}, YEAR(@cell) >= 2024))


    Gia Thinh Technology Co., LTD - Smartsheet Solution Partner.

Answers

  • Gia Thinh
    Gia Thinh ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Saj

    COUNTIFS returns a specific counting number, not a list.

    You may want to try COLLECT function that return a list/range and is used within another function. For example, try this one:

    =JOIN(COLLECT({Your Project List Range}, {Completed Range 1}, $Label@row, {Completed Range 2}, "NPD$1", {Completed Range 3}, YEAR(@cell) >= 2024))


    Gia Thinh Technology Co., LTD - Smartsheet Solution Partner.