Countif Date Formula



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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!