UNPARSEABLE error using COUNTIFS
I am using the following formula to count all bids that were won in the month of January by looking for January in the "Awarded CT Reported Date" column and has a "Y" in the "Won Bid?" column. Both statements work independently, but when I combine them I keep getting an unparseable error. What am I doing wrong?
=COUNTIFS([Awarded CT Reported Date]:[Awarded CT Reported Date], IFERROR(MONTH(@cell), 0) = 1), [Won Bid?]:[Won Bid?], "Y"
Answers
-
Looks like you are missing a closing parentheses.
-
@David Langley There is an accidental closing parenthesis after =1
Try this one:
=COUNTIFS([Awarded CT Reported Date]:[Awarded CT Reported Date], IFERROR(MONTH(@cell), 0) = 1, [Won Bid?]:[Won Bid?], "Y"
@Leibel S Smartsheet will auto-close any missing parenthesis (or it used to). So in this case that wasn't the issue. The closing parenthesis ended the Countifs early and there was still extra data that was trying to be factored in to the equation.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!