what is the correct syntax for CCOUNTIFS to only count items where a date is blank

Options

For example I am counting all items with a Red Status using =COUNTIFS(Status:Status, "Red")

However, I only want to count items Red if the Date Added Column is Blank.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!