Help

Creating a filtered rollup formula based on outside column

1088 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Bryan_Goldberg
4 - Data Explorer
4 - Data Explorer

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:
56%20PM

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.

1 Reply 1
Bryan_Goldberg
4 - Data Explorer
4 - Data Explorer

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