Sum of durations excluding the parents
Here's a demo project and I am trying to build queries to extract some data and could do with some help with building the appropriate queries.
- I'd like to query the duration of all the tasks in the sheet. in this case that number would be 20 weeks. However I don't want any of the parent item durations to be included - so I don't want Project1 to be included in the sum since that results in double counting.
- Similarly I would like to sum up the duration for all tasks that don't have owners assigned. In the example below that should be 6 weeks. Again I am looking for a query that excludes the "Project 1" row.
- Finally is there a way to reflect effort vs calendar time (which is what the duration field appears to be)
Any help would be appreciated. I've just started using smartsheets
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.