Return a line item that is a past due order?

Options

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!