Time Tracking

Empowered by the Excel 365 Connector, users can effortlessly input crucial data concerning both the initial projections and the ongoing assessments of time required for work tasks. Additionally, if the corresponding options are activated in Jira, users can seamlessly configure and manage the “Original Estimate” and “Remaining Estimate“ fields directly from their spreadsheet interface.

To utilize this function effectively, ensure that the “Time tracking” field is enabled alsow the “Original Estimate” and “Remaining Estimate” fields can be enabledfor data validation purposes. By default, these fields are hidden but can be activated through the “Schema” menu:

Open

After that column “Time Tracking” will be displayed. If issue doesn’t have added value in “Original estimate” or “Remaining Estimate”, it will be empty. If there are already set some value from Jira side, it will be displayed as “R: remaining estimate time; O: original estimate time”:

Open

Now you can set “Original estimate” and “Remaining Estimate” while creation new issue by EC365 or modify it. You don’t need to put values for both fields, you can use only “R:” for “Remaining Estimate” or “O:” for “Original estimate”, but if you want to set both, it need to be separated by “;”. The order of fields is arbitrary during setting, but fetched one will be always as “R: remaining estimate time; O: original estimate time”.

After set you need only “Send Issue” and changes will be visible in Jira.

Information about time is automatically converted by Jira, so if you put as a value “72h” in EC365, it will be changed to 1w 4d in Jira.

At this article you can find answer for following questions:

Can’t update “Estimate” field