Dashboard formulas - Need to count if a person is included in Owner Column and the task is not close

Trying to calculate the number of tasks by person that are not closed. I currently have:

=COUNTIFS({Tracker Range 6}, ="Andy", {Tracker Range 2}, <>"CLOSED")

Where the Range 6 is the Owner column and Range 2 is the Status Column (Open, Closed, Hold).

I am getting responses, but I think it is only counting where the owner is the only entry in the cell...many have shared ownership. How do I indicate where the name is included and not the only entry?

Find more posts tagged with

Formulas

Support

Comments

Nic Larsen

Try something like this:

=COUNTIFS({Tracker Range 6}, FIND("Andy", @cell) > 0, {Tracker Range 2}, OR(@cell = "Open", @cell = "Hold"))

JFrye

Thank, Nic! Worked like a charm! Appreciate it!

Nic Larsen

Perfect, glad to help.

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…
Issue with automation process reporting a date in a special column
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…