Structure Sprint capacity formula- before sprint

Question

Hey All,

I need help with a structure formula for total sprint capacity before the sprint starts (team members x days of sprint).

I have this formula but it calculates total remaining capacity in the sprint:

if !issuetype: max#strict{days_between(sprint.filter($.name = split(split(parent{summary}, ": ").last(), " (").first()).startdate,
sprint.filter($.name = split(split(parent{summary}, ": ").last(), " (").first()).enddate)} * array#strict{assignee}.unique().size()

Thanks!

Ashley F · Answer

Hi @Stepan , This formula returns "0" and other low numbers on my Structure for teams that have 5+ members and 10 sprint days. This is why I assumed that the formula was returning the remaining capacity after a sprint has begun.

I want to show something such as 400hr capacity in a sprint, or even better, if I can show 80% of that, as this is our actual allocation.

Stepan Kholodov · Answer

Hello @Ashley F

The formula you mentioned does exactly what you described - it multiplies the number of team members in a Sprint(the number of Assignees of its issues) by the number of days of a Sprint (days between its Start & End dates). So it's not clear to me what exactly do you mean by 'before sprint' in this context.

But we sure have a closer look at your setup and requirements, and recommend a fitting solution. If you need our help, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)