Count Decisions in a Month, where decisions are made...

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!