Count if text contains certain words in one column and another column is not blank
Hello!
I am stumped on a formula. I am trying to count the number of times the task "Full DD" is listed in the task column the cell in the "Number Completed" column is not blank.
I have this formula: =COUNTIFS((Task:Task), "Full DD")(AND([Number Completed]:[Number Completed], NOT(ISBLANK(@cell)))) but it keeps coming back #UNPARSEABLE. What am I doing wrong?
Thank you!!
Tags:
Best Answer
-
Lets try correcting some syntax issues first and see if it works...
=COUNTIFS(Task:Task, @cell = "Full DD", [Number Completed]:[Number Completed], @cell <> "")
Answers
-
Lets try correcting some syntax issues first and see if it works...
=COUNTIFS(Task:Task, @cell = "Full DD", [Number Completed]:[Number Completed], @cell <> "")
-
That worked! Yay!!!
Thank you so much for your help!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!