CountIFs (Time and Blanks)


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!