Count multiple blank columns

cyndi2403 ✭✭✭
edited 12/09/19 in Formulas and Functions


I have a task board with multiple columns like Original Due Date, Current Due Date, Goal, and Status.  I am trying to come up with a formula that "audits" the data for blanks so we can easily see that Person A has 5 tasks that have blank columns they need to fill out. 

In the formula below [Column7]$20 is the person's name.  I have figured out how to count based on one column (Current Due Date) but I think I need some kind of OR statement to say count if Current Due Date OR Original Due Date OR Goal OR Status are blank.  I haven't been able to figure out the syntax for this.  Any help is appreciated...thanks in advance!


=COUNTIFS({Product Team Task Board Assigned To}, [Column7]$20, {Product Team Task Board Current Due Date}, ="")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!