CountIFs (Time and Blanks)

Options

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.


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!