How to count grandchildren.

I'm trying to count how many grandchildren I have in a chart, how do I create the formulas for this?

Note that I would be adding and removing rows and I need this counter to keep updating with rows inserted and removed.

Example:

Find more posts tagged with

Hi,

Have a look at this thread.

Did that give you the solution?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

=COUNT(DESCENDANTS())

This will count ALL descendants (child and grand child rows)

=COUNT(CHILDREN())

This will count only the direct children rows (not the grandchildren rows)

Subtract the number of children from the number of descendants to find the number of grandchildren.

=COUNT(DESCENDANTS()) - COUNT(CHILDREN())

Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto