Formula should be returning a value of 3 not zero

J. Earp

I have created the below formula to calculate the number of projects by application (primary column) whose status is Not Started and belongs to group TMOEX. I should be getting a value of 3 but it is returning 0. Can anyone help identify what is incorrect in my formula? Thank you!

=COUNTIFS({Project Status}, "Not Started", {ALL COES}, HAS(@cell, "TMOEX"), {Application}, [Primary Column]@row)

Yvonne Smythe

Hi @J. Earp - Are you envisioning something like this?

TMOEX - Not Started (column formula): 
=COUNTIFS([ALL COES]@row, "TMOEX", [Project Status]@row, "Not Started")
Totals:
=SUMIF([TMOEX - Not Started]:[TMOEX - Not Started], "1")

Depending on your next steps you could also use a Lookup to pull in project names or just start off initially using the Smartsheet Pivot(if you have it):

https://help.smartsheet.com/articles/2476736-get-started-pivot