CountIFS and Summery Date Field
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]#)
Can anyone provide some help?
Best 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.
Answers
-
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.
-
That worked. Thanks for the insight, Mark!
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
