COUNTIF/COUNTIFS Formula Help

Bert Guymer

Good Day! I have an intake sheet, that I want to use to create a Summary so I can add graphs to my Dashboard.

I'm looking for a formula that will show how many projects each manager has assigned. The dropdown on the reference intake sheet has "Assigned", "In Progress" and "Completed". I am hoping to create a graph/chart, by Manager with a column (or metric) for each stage as a number. Not sure what I am doing wrong…but I've been watching videos, retaking courses and retrying this for the last four hours.

I can get the total projects in scope by Assigned, In Progress and Completed…but cannot get it by Manager….which should be simple enough. Any help would be appreciated, and it might save my laptop from harm.

kowal

hi @Bert Guymer,

Countif and Countifs are pretty straight forward formulas.

I would use the Sheet Summary fields to calculate it or create extra sheet for calculations where you can reference another sheet. anyway if you want to check how many Complete projects are assigned to Thomas you shall use countifis and it shall be like: =countifs(Assigned:Assigned, "Thomas", Status:Status, "Complete") - assigned is the name of the column you keep the name of PM and status is the column where you keep their status of project.

https://help.smartsheet.com/function/countifs

kowal

hi @Bert Guymer,

Countif and Countifs are pretty straight forward formulas.

I would use the Sheet Summary fields to calculate it or create extra sheet for calculations where you can reference another sheet. anyway if you want to check how many Complete projects are assigned to Thomas you shall use countifis and it shall be like: =countifs(Assigned:Assigned, "Thomas", Status:Status, "Complete") - assigned is the name of the column you keep the name of PM and status is the column where you keep their status of project.

https://help.smartsheet.com/function/countifs

Bert Guymer

Appreciated!