How to make Project with Work Breakdown Schedule Template display a count of tasks at risk?

AllisonCS

Hello,

I am using the Project with Work Breakdown Schedule (WBS) template. In the Project Dashboard, there is a section for Metrics that displays Tasks at Risk. There is a column in the Task Tracker sheet with check boxes that this seems to point to. However, it does not display a count of the number of checked boxes. It displays the label "Tasks at Risk," but doesn't give me a count. Can you please help me fix this?

Thank you,

Allison

kowal

hi @AllisonCS,

you would need to use formula in some admin sheet to calculate how many of those Risk Checkboxes are checked. you can do it simply with =countif formula.

AllisonCS

Hi @kowal ,

Thank you. That workaround works. It's silly that it is necessary. It should just summarize that data correctly when it points to that summary data in the original sheet. Ugh!

Now, though, I have a followup question. In the original version of this metric, it showed the an alert flag. Now, there is no alert flag to draw your eye. Do you know how to force that to still be there? What would be even better is if I could conditionally format the text color in the project dashboard to be red when at risk count is >0. I can do that formatting in the sheet, but it isn't reflected in the project dashboard. Do you know how I can address either of these options?

Thank you,

Allison

kowal

hi @AllisonCS,

When you have the column with Checkbox you can choose either checkbox, flag or star to be shown.

Please go into the properties of this column and choos flag instead of checkbox. You can also use conditional formating to make the cell red if the checkbox is chosen. Quite many options there are to draw the eyes.

AllisonCS

Hi @kowal ,

It's not the column that I'm trying to change, it's the display of the metrics section on the project dashboard. I'll attach some pictures to show what I mean better:

This is what it looks like in the original template without displaying the count:

Screenshot 2025-04-29 at 1.40.12 PM.png

It doesn't give the counts, which renders that metric display useless. This is the fix that I was able to do with your kind help!

Screenshot 2025-04-29 at 1.46.33 PM.png

Screenshot 2025-04-29 at 1.41.56 PM.png

To make that, I created a new sheet to use the countif formula like you suggested to count the number of tasks with "at risk" checked in the task tracker sheet. I have conditional formatting on the sheet, but it would be nice if the dashboard gave some better visual cue for that metric. I can change the font of the title, but not of the actual metric. I can't change anything in the sheet column that counts the checked boxes because its format has to be number/text for the formula.

Thank you,

Allison

kowal

hi I think there might be sth with your countif function….

shall it not be =countif({range}, "Criteria") so in your case =countif({Column:Column}, 1)

where column is a range from of checkboxes in the other sheet of course.