Count Number of Tasks

eahills · 03/15/23

Hi, I am trying to build some dashboards widgets that sum up the number of tasks in a list. The list includes multiple "parent" type rows, but I only want to count the child fields. I created a 'heirarchy' class, but the problem is I need to sum both the 1s and 2s based the various categories.

Also - how do I actually get the dashboard widget to display the # in a text type field?

Victoria_Indimar · 03/15/23

Hello@eahills! Instead of doing the hierarchy/parent count, I've done a helper column for child count. Then I count the tasks where children = 0 to get my true Task Count. Hope this helps!

eahills · 03/15/23

@Victoria_Indimar-- thanks -- what is the formula to create a child count?

Victoria_Indimar · 03/15/23

=count(children([task name]@row))

eahills · 03/15/23

@Victoria_Indimar- awesome. Super helpful, done. And how do I roll the sum of the children into a metric widget in a dashboard?

Victoria_Indimar · 03/15/23

To add to a dashboard, I typically create a separate summary sheet that rolls up the information you want to generate a chart/graph from.

For example, I see you have Milestones to organize your tasks. Maybe if you have something like Status or % Complete, you can create a little table using formulas to count the # of tasks that meet the criteria.

Then from the Dashboard chart widget, you would select the table from the summary sheet.

eahills · 03/15/23

Ok. Interesting@Victoria_Indimar...someone who had created this widget previously referenced a sheet summary data field from my primary sheet....what exactly does this do?

Victoria_Indimar · 03/15/23

Ah! Yeah, you could do that as well. It'd be the same formulas you used for each field you have there in the sheet summary. I like to use a separate sheet just to help organize, add more as more metrics are needed/requested, and quickly see how the data rolls-up.

eahills · 03/15/23

Curious where these calculations are even located for the Sheet Summary Data...?

Victoria_Indimar · 03/15/23

Sheet Summary Data comes from the selected sheet's Summary, available on the right vertical menu.

You'd create a field and enter the formula there, for example:

Count Number of Tasks

Answers

Help Article Resources

Categories