COUNTIFS help - getting UNPARSEABLE

Options
System
System Employee Admin
in Formulas and Functions
This discussion was created from comments split from: Count of cells in a date range.
· Share on FacebookShare on Twitter

Answers

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

    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.

    · Share on FacebookShare on Twitter
  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    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")

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!