Creating a filtered rollup formula based on outside column


#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.


#2

If this isn’t possible I’m totally cool with that but just was curious if anyone had any thoughts on this.