How can I count blank or filled in cells?
Ultimate goal: To have status column update to Complete once all cells are filled in
Problem: I'm trying to count 15 cells on a row (not a range), find out if they are all filled in, then once all the selected cells are filled in, the column I'm using for this formula will turn into a check box where I can create automation to have the status turn complete. I was getting the error of #booleanexpected but now that I made it a text column it just says #UNPARSEABLE.
Formulas I've tried: =COUNTIFS(ISBLANK([Strives to Exceed Organizational Goals]@row,(@CELL), [Ensures Accountability]@row,(@CELL), [Makes Informed Decisions]@row,(@CELL)
I've also tried formula =COUNTIFS([Service-Oriented]@row, ISBLANK([Service-Oriented]@row, [Instills Trust]@row, ISBLANK([Instills Trust]@row), [Wows the Customer]@row, ISBLANK([Wows the Customer]@row)))
This is the only way I can figure out how to count blanks or non-blanks then once it is at zero, have automation update status to Complete. (If you have better solution, please LMK)
Help Article Resources
Check out the Formula Handbook template!