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

skytriv

I am still learning Smartsheet and formulas so please bear with me lol...

I am trying to show in the Sheet Summary report that counts the number of open tasks each one of our validation engineering techs have. Ideally I want to this information to be pulled from the column [Validation Tech/Engineer] and the # of open tasks would be when [Work Completed] field is still blank

so far I have this as the formula. But I do not know how to get the if blank portion to work

=COUNTIFS([Validation Tech/Engineer]:[Validation Tech/Engineer], "Bob Smith")

Thank you!

Mike TV

@skytriv

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

skytriv

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

Andrée Starå

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!

skytriv

This what I wrote. Thank you.

Andrée Starå

@skytriv

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!

skytriv

I am still getting the UNPARSEABLE error

Andrée Starå

@skytriv

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)

skytriv

I just shared it with you. Thank you!

Andrée Starå

@skytriv

Excellent!

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

Andrée Starå

@skytriv

I found the issue.

You have one space after the Work Completed name in the column. If you remove that, it will 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!

skytriv

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

Andrée Starå

@skytriv

Excellent!

You're more than welcome!

✅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!