Use Countif to count the number of tasks assigned to a worker?
Hi, I'm sure there is a quite dimple solution to the this, but I am having trouble.
I want to count the number of rows assigned to each contact, and I used the formula below:
=COUNTIF(Assigned Work:Assigned Worker, "contactname")
The formula returns the error #UNPARSEBALE
How can I fix this?
Comments
-
Whenever a column name contains a space, special character, or number, the column name should be wrapped in [Square Brackets].
=COUNTIF([Assigned Work]:[Assigned Worker], "contactname")
-
Thank you for responding Paul,
But even after adding the square brackets, it still returns an error.
-
Hi Valencia,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Check your column names. You have one as "Assigned WORK" and the other as "Assigned WORKER". If you are only referencing one column, then one of those column names is incorrect.
My apologies for not catching that the first time.
-
Paul,
Nice catch!
I didn't see it either. Some combinations are hard to spot. Probably some science to it.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I've done the same thing to myself a few times and then spent hours trying to figure it out. That's why I have gotten into the habit of clicking on the cells themselves. That way I KNOW the column names are correct. If I am doing a column reference, I will select a few cells within the column and then just delete the row references.
If that's any clue how often I messed the column names out, I had to change my "standard practice" in formula writing to account for my fat fingers. LOL
-
Haha!
If something isn't working, then check what fat fingers did!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Pretty much sums it up. Hahahaha
-
Thank you both so much!
-
-
Happy to help!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!