Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Structure formula to compare workdays to original estimate

Lean Li August 29, 2024

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!

 

1 answer

Suggest an answer

Log in or Sign up to answer
0 votes
Stepan Kholodov _Tempo_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 1, 2024

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)

TAGS
AUG Leaders

Atlassian Community Events