COUNTIFS formula that compares dates in two columns as a criteria

Steve Fogel
Steve Fogel ✭✭✭
edited 12/09/19 in Formulas and Functions

Here's what I'm trying to do.  KPI is a check box field (Key Performance Indicators).  Status is a single choice list box field.  Actual Finish and Plan End date are date fields.  I want to count the number of KPI rows with a check mark where the status is complete and the Actual finish date is on or before the plan end date.

Here is the formula I am using.

=COUNTIFS([KPI]:[KPI], 1, [Status]:[Status], "Complete", [Actual Finish]:[Actual Finish],<=[Plan End Date]:[Plan End Date])

If I remove the date comparison the calc works fine. 

Any suggestions.






Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!