Skip to main content

Creating a filtered rollup formula based on outside column

  • March 24, 2018
  • 1 reply
  • 20 views

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.

This topic has been closed for replies.

1 reply

  • Author
  • New Participant
  • March 27, 2018

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