Use Countif to count the number of tasks assigned to a worker?

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

Paul Newcome

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.

Andrée Starå

Paul,

Nice catch!

I didn't see it either. Some combinations are hard to spot. Probably some science to it.

Paul Newcome

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

Andrée Starå

Haha!

If something isn't working, then check what fat fingers did!

Paul Newcome

Pretty much sums it up. Hahahaha

Valencia C.

Thank you both so much!

Paul Newcome

Happy to help!

Andrée Starå

Happy to help!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…