Count if there is a blank in another column

Options

I am looking for a formula that will count how many times Alex's name shows up in the "assigned to" column but only if the "complete date" column is empty. Is this possible? Thank you!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!