CountIFs (Time and Blanks)

Samantha Wiatrek

We use Smartsheet to provide customers with an invoice and allow them to give us a PO. I am wanting to create a formula that will count invoice past 90, 60, 30 days that have a blank in the PO #. I am pretty sure I have FINALLY figured out the date function, but can't figure out how to "marry" it with the blank function. I am open for an and all help! Thank you in advance.

Paul Newcome

Ok. You are going to want to start by switching from COUNTIF to COUNTIFS to allow multiple range/criteria sets. Then it would look something like this...

=COUNTIFS([Date Sent]1:[Date Sent]54, <TODAY(-90), [PO #]:[PO #], @cell = "")

Paul Newcome

Can you provide the formula you are using to incorporate the date? That way we can go ahead and build off of that instead of trying to "reinvent the wheel".

Samantha Wiatrek

Of course. Thank you.

=COUNTIF([Date Sent]1:[Date Sent]54, <TODAY(-90))

Paul Newcome

Ok. You are going to want to start by switching from COUNTIF to COUNTIFS to allow multiple range/criteria sets. Then it would look something like this...

=COUNTIFS([Date Sent]1:[Date Sent]54, <TODAY(-90), [PO #]:[PO #], @cell = "")

Samantha Wiatrek

This worked! Thank you so much I have been racking my brain trying to figure this out. Sometimes all you need to do is ask. Have a wonderful evening...

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response(s) as "helpful". This will let others searching for a similar solution know that one may be found here.