Countif using Dates and another Range

Options
Phil B.
Phil B.
edited 12/09/19 in Formulas and Functions

I'm trying to use CountIf using the my auto filled date column and another column. The 2 parts of the formula I have come up with work independent of each other, but when I try to put them together I recieve the #INCORRECT ARGUMENT   reply. Not sure what is wrong. Below is a copy of my Formula.

 

=COUNTIF([Request Create Date]:[Request Create Date], >=DATE(2018, 1, 1), [Issue/Nonconformance]:[Issue/Nonconformance], "Install Vendor Workmanship")

 

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!