Countif Date Formula

B_Robinson

Hello,

I'm having an issue with a countif formula. I'm trying to countif the number for submissions that happened within a specific month on another sheet but keep getting an #INVALID DATA TYPE. I checked the column type in the other sheet and it is a date column. The formula works in the actual sheet with the data, but I'm trying to have the data calculated in a metric/roll-up sheet. Any ideas on the issue?

ShelbyWarren

@B_Robinson Here's a solution:

1. In the Source Sheet, create a "Month Number Helper" column that references the date, with this formula in it: =MONTH([Submitted Date]@row)
2. To get the requests per month, in the metric sheet insert this formula, =COUNTIF({Request - Month Number Helper}, [Month Number]@row)

Raghavendra Nayak

Smartsheet Reports can help to get the number of date entry using summarize by count