CountIFS and Summery Date Field

Rob McMurtrie
Rob McMurtrie ✭✭
in Formulas and Functions

Having trouble with the following formula returning an "Unparseable" error.

=COUNTIFS(Type:Type, "Release", Status:Status, "Complete", Due Date:Due Date, >=[Current Quarter Start]#, Due Date:Due Date, <=[Current Quarter End]#)

Smartsheet capture.PNG

Can anyone provide some help?

· Share on FacebookShare on Twitter

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer βœ“

    Try:

    =COUNTIFS(Type:Type, "Release", Status:Status, "Complete", [Due Date]:[Due Date], >=[Current Quarter Start]#, [Due Date]:[Due Date], <=[Current Quarter End]#)

    Column names with spaces or special characters need to be placed in square brackets.

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

    · Share on FacebookShare on Twitter

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer βœ“

    Try:

    =COUNTIFS(Type:Type, "Release", Status:Status, "Complete", [Due Date]:[Due Date], >=[Current Quarter Start]#, [Due Date]:[Due Date], <=[Current Quarter End]#)

    Column names with spaces or special characters need to be placed in square brackets.

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

    · Share on FacebookShare on Twitter
  • Rob McMurtrie
    Rob McMurtrie ✭✭

    That worked. Thanks for the insight, Mark!

    · Share on FacebookShare on Twitter
  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Glad you found a solution. Thank you for contributing to the Community.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

    · 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!