I am trying to find a way to calculate the number of workdays and compare it to the sum of original estimate for each assignee in my sprint planning structure. The below formula is not working, so I am reaching out for formula experts for help. Any ideas on how to proceed with this use case?
WITH businessDays = WORKDAYS("2025-01-01", "2025-01-31")
WITH originalEstimateSum = SUM#{originalEstimate}
IF originalEstimateSum < businessDays: "Under allocated"
Thank you so much already in advance!
Hello @Lean Li
If you have Structure.Gantt installed, you can use the CALENDAR_DURATION() function for calculating the number of only work days between two dates. Otherwise, you can only do it by defining the work schedule within the formula. This approach can give you the expected result in many cases but it's not bulletproof - the calculation can still return approximate values, depending on the use-case.
A formula like this can be used:
WITH start = created: WITH end = today(): WITH temp = weekday(start) + days_between(start, end): WITH days = temp - weekday(start) - FLOOR((temp / 7) * 2): days
It returns the number of work days, so for correct comparison, the sum of Original Estimate should also be converted in days only using the jira_days() function.
Best regards,
Stepan
Tempo (the Structure app vendor)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.