COUNTIFS help - getting UNPARSEABLE

This discussion was created from comments split from: Count of cells in a date range.

Answers

  • Sharon Castiglia
    Sharon Castiglia ✭✭✭✭✭
    edited 01/30/20

    Tried this formula:

    =COUNTIFS([Install Schedule];[Install Schedule], >DATE(2018, 12, 30),[Install Schedule]:[Install Schedule], <DATE(2019, 01, 07), [Install Complete]:[Install Complete], ="Yes")

    and I am getting #UNPARSEABLE .

    I am at a loss.

    Please and Thank you

    Sharon C.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Your first range has a semicolon as a separator between the column names instead of a colon. Try this instead...


    =COUNTIFS([Install Schedule]:[Install Schedule], >DATE(2018, 12, 30),[Install Schedule]:[Install Schedule], <DATE(2019, 01, 07), [Install Complete]:[Install Complete], ="Yes")

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!