Creating a filtered rollup formula based on outside column
0
1351
1
I’m using the Product Planning template and my goal is to have total duration left for each Sprint.
What I did is in the Stories table right next to “Client Points column” I added in a Time column which shows the amount of estimated time it will take for each Story.
Then In the Sprints tab, right next to the “Client Points” column I added a Rollup column like so:
What I was hoping to do is instead of just rolling up and getting the sum of all the Time values in each story in the sprint, I wanted to leave out the time values that had the “Built” column checked; aka only have the time for the remaining story items that have not been built.
Does anyone have any ideas on how I could accomplish this.
