Currently we have a table with formulas in Excel which tracks our team's capacity and whether they can take more issues on each sprint. This is very useful when planning the team sprints and would like to see if there is a way to replicate this behaviour in JIRA so we don't have a need for Excel anymore.
Basically this is how the table looks:
I know I can enter time estimates for each issue and then track time against those but is there a way to set up time tracking for the whole sprint? For example if during one sprint a team member is on vacation, the team's capacity should be less than when he is in the office, therefore, the team should see this during the planning meeting and assign less issues for that sprint. Any way to achieve this?
Its not a must have right now, but definitely a nice to have.
Thanks!
