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:
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.