Count Number of Tasks


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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!