Count Not Working– How to Count Number of "Complete!" Statuses

On this table:

I’m trying to create a progress bar. I want the progress bar to show the number of tasks in the “Task Status” column that are “Complete!” relative to the TOTAL number of statuses in the “Task Status” column.

I can get the formula to count the TOTAL number of statuses in the “Task Status” column. But I’m not able to get it to count ONLY the ones that are “Complete!”. It keeps yielding a value of “1”, even if there are 5, 6, 7, etc. “Complete!” task statuses.

This is my formula for the TOTAL number of statuses:

And this is my formula for counting only the “Complete!” statuses:

I am not sure if I understand it fully, but I believe you may be using the wrong formula for the Completed Tasks column.

You should try using the CountIf() formula instead.
The Completed Tasks column would look something like this:

CountIf(thisRow.[Task Status], CurrentValue = "Complete!")

See the explanation below if you’d like to understand why using the Count() formula was always returning the value 1.

Why Count() always retruns 1 in this case

The formula Count() should accept only a list as a parameter, but in the Complete Tasks column, you are instead providing an expression.

The expression is “the list of statuses in this row is equivalent to Complete!”, which will always return “false”, as a list cannot be equivalent to a Status.

The Count() formula then counts that “false” value it got from the expression as one list item, and that is why it always shows as 1.

Hope that helps.

YESSS! That worked! Thank you so so so so much!!!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.