COUNTIF (Counting a column based on other column Information)


Using 2 columns (Status) & (Tracking) I'm trying to count the amount of "complete" status in the Status column where the Tracking column is not Past Due. Below is the formula I created.

=COUNTIF(AND(Tracking:Tracking, <>"Past Due", Status:Status, "Complete"))

It's not taking the formula, any thoughts?

Bonus Question* ***

Eventually my plan is to due this based on information in a referenced sheet. Any ideas on if that's possible?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!