Count if there is a blank in another column


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!