Return a line item that is a past due order?

Twitch the Itch

I have a list of orders with an "Estimated Receive Date" and an "Arrived" date. I want to return the PO number if the received date is blank and the estimated received date is less than today. What formula can I use for this?

Matt Johnson

Hi @Twitch the Itch

I think this formula should work if you have a column named "PO Number" for the PO number:

=IF(AND([Estimated Receive Date]@row < TODAY(), Arrived@row = ""), [PO Number]@row, "")

I hope that helps.

Matt

Twitch the Itch

Thanks Matt Johnson,

I will try this formula.