Count Decisions in a Month, where decisions are made...
I am trying to determine how many credit decisions are made in a month.
I have a date column that indicates the decision date and have popped in a helper column to change an April date to "4" and then COUNTIF if the answer is 4.
I used: =MONTH([DECISION DATE]@row)
The issues arises where no decision is yet made and in my helper column (ClosedMonth) it returns #INVALID DATA TYPE where there is no data in the 'Decision Date column.
Even when the month correctly changes to '4' in the helper column, in my formula it will not count the number that =4 (April), as there is data in the column that has #INVALID DATA TYPE
My Decision Date is a Date column and ClosedMonth a Text/ Number column.
I have also tried exploring IFBLANK, however encountered similar issues.
Many thanks in advance!
Best Answer
-
Your syntax is a little off. Move one of the closing parenthesis at the end to after the cell reference to close out the MONTH function.
Answers
-
Try wrapping the formula that outputs the month numbers in an IFERROR statement.
-
Thanks Paul. Now i seem to be getting an error across every cell, not just those that had nothing in the corresponding column.
INCORRECT DECISION is the new error though.
Using IFERROR I am using; =IFERROR(MONTH([DECISION DATE]@row, " "))
It doesn't change if i pop another number between the " "
-
Your syntax is a little off. Move one of the closing parenthesis at the end to after the cell reference to close out the MONTH function.
-
Got it! Thank you Paul.
This is what worked; =IFERROR(MONTH([DECISION DATE]@row), " ")
Appreciate the support!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 217 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!