How to write formula that states how many open tasks a person has based on another field being blank

=COUNTIFS([Validation Tech/Engineer]:[Validation Tech/Engineer], "Bob Smith", [Work Completed]:[Work Completed], ISBLANK(@cell))

Thank you, when I tried that I received the #UNPARSEABLE error

Hi @skytriv

I hope you're well and safe!

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

This what I wrote. Thank you.

Happy to help!

Try this.

=COUNTIFS([Validation Tech/Engineer]:[Validation Tech/Engineer], "Bob Smith", [Work Completed]:[Work Completed], @cell = "")

Did it work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

I am still getting the UNPARSEABLE error

Strange!

Ensure that there aren't any extra spaces; if that doesn't fix it, I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I just shared it with you. Thank you!

Excellent!

I'll take a look and get back to you.

I found the issue.

You have one space after the Work Completed name in the column. If you remove that, it will work.

Thank you, that worked. Have a great day and thanks so much for your help!