3

Hi,

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)

Functionality

Comments

Try this: 

=COUNTIFS([Issue Date]:[Issue Date], NOT(ISBLANK(@cell)), [Responded Date]:[Responded Date], ISBLANK(@cell))

Your formula will work if you add @row to the columns:

=IF(AND(NOT(ISBLANK([Issued Date]@row)), [Responded Date]@row = ""), 1, 0)

Thank you both.

I used Brians advice in this case since it more closely aligned with what I had - A face palm moment when I realised I hadn't used @row.

Much appreciated.