Countif query with blanks
I've had a search through the community but I can't seem to get a working formula so hopefully someone can help me.
I'm trying to count if Issued Date is not blank and Responded Date is Blank.
=IF(AND(NOT(ISBLANK([Issued Date])), [Responded Date] = ""), 1, 0)
Help Article Resources
Check out the Formula Handbook template!