Countifs function returns #UNPARSEABLE

TJE · 08/21/23

Hello,

I would like for the equipment status to be counted if it is "Issued", the equipment type is "Tablet" for a specific region. I have changed the formula multiple times, each time "UNPARSEABLE".

The formula below is the last one I used.

=COUNTIFS({Asset Tracker 2 Equipment Status}, {Asset Tracker 2 Equipment Status}, "Issued", {Asset Tracker 2 Equipment Type}, "Tablet", {Asset Tracker 2 Region}, [Office Location Information]@row])

Please advise on what correction are needed.

Thanks so much!

Paul Newcome · 08/22/23

I need more coffee...

The first range does not need repeated.

Paul Newcome · 08/21/23

I don't see any immediate syntax issues. Can you please provide a screenshot of the formula open in the sheet as if you are about to edit it?

Andrée Starå · 08/22/23

https://community.smartsheet.com/discussion/109229/countifs-function-returns-unparseable

Hi,

I hope you're well and safe!

You have an extra square bracket at the end.

=COUNTIFS({Asset Tracker 2 Equipment Status}, {Asset Tracker 2 Equipment Status}, "Issued", {Asset Tracker 2 Equipment Type}, "Tablet", {Asset Tracker 2 Region}, [Office Location Information]@row])

Try this one.

=COUNTIFS({Asset Tracker 2 Equipment Status}, {Asset Tracker 2 Equipment Status}, "Issued", {Asset Tracker 2 Equipment Type}, "Tablet", {Asset Tracker 2 Region}, [Office Location Information]@row)

Did that work/help?

I hope that helps!

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!

Paul Newcome · 08/22/23

I was so focused on commas and syntax that I missed the square bracket.

Andrée Starå · 08/22/23

https://community.smartsheet.com/discussion/comment/391867#Comment_391867

Easy to miss!

TJE · 08/22/23

Thanks Andree and Paul!! I really appreciate you both taking a look at this.

So, I removed the bracket Andree referenced. Now it is saying "INCORRECT ARGUMENT SET".

Below is the formula opened as if I am about to edit it...

Thanks!

Andrée Starå · 08/22/23

https://community.smartsheet.com/discussion/comment/391889#Comment_391889

Happy to help!

Strange!

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

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

Paul Newcome · 08/22/23

I need more coffee...

The first range does not need repeated.

Andrée Starå · 08/22/23

https://community.smartsheet.com/discussion/comment/391903#Comment_391903

Haha! You and me both!

TJE · 08/22/23

@ Paul...And just like that, issue resolved!!

Thanks a zillion Paul and Andree :)

Paul Newcome · 08/22/23

Happy to help. 👍️

Andrée Starå · 08/22/23

https://community.smartsheet.com/discussion/comment/391909#Comment_391909

Excellent!

Happy to help!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!

Countifs function returns #UNPARSEABLE

Best Answer

Answers

Help Article Resources

Categories