I am importing the “original estimate” that my developers set on a task from JIRA into Monday.com. JIRA stores all time in seconds, so in Monday, it shows 28,800 for one day. I want to calculate the start date and update the timeline based on the due date and JIRA estimate. I can’t figure out how to do it. Any thoughts?
1 Like
Hey @justin.fansler so, since Jira’s time estimate function isn’t really compatible with monday’s date and timeline features, you have to find a way to convert it relatively easily.
- You could create a formula column in monday called “Jira Estimate (days)” for example. Then, make the formula something like this:
{JIRA Original Estimate} / 28800
That tells you the number of 8-hour workdays needed for a project.
- If that’s enough, you could back-date your start dates manually. But if you’re doing this A LOT, then create another column for the start date. Use a formula to calculate the start date based on the due date and converted Jira estimate.
WORKDAY({Due Date}, -{JIRA Estimate (days)})
This would subtract the estimated number of 8-hour workdays from the due date to get the appropriate start date for you automatically. The WORKDAY function excludes weekends.
If you need to account for holidays in your start date calculation, you can use the WORKDAY.INTL function instead of WORKDAY . This function allows you to specify a list of holidays to exclude.
Let me know if that helps!
To convert the time from JIRA (stored in seconds) and accurately update the timeline in Monday.com, you’ll need to create a formula column that converts seconds into days and then calculate the start date based on the due date minus the estimated days. This can be done directly within Monday.com using a combination of formulas and automation.