The ADO data connector for WorkBoard allows the user to pull progress based on available queries in ADO and specified issue status.
Once you've created an objective, you can create a key result that pulls data from your Azure DevOps projects; as work items are completed in Azure DevOps, your key result is automatically updated to reflect the progress made.
- The IT admin for your organization may need to approve the connector for the first time if the App is configured to require approval.
Add Key Results from Azure DevOps
- Hover over your Objective and click the Kebab.
- Select Edit Settings.
- Select Add another Key Result.
- Select Advanced Options.
- Choose Pull data from external applications.
- Pick Azure DevOps from the list of integrations.
Note: To create your first key result sourced from Azure DevOps, you'll be asked to authenticate to an Azure DevOps instance through OAuth or by providing a PAT (personal access token).
Once you are authenticated, select a project within your Azure DevOps instances by searching for its name.
Measure by Work Item ID, Work Item Name, or Saved Query
After selecting a project, you'll have the option of entering work item IDs, searching for specific work items by name, or selecting a saved Azure DevOps query.
Work Item ID and Work Item Name
- Measure only the work items that you have identified, or both those work items and their children (this is the child link relationship in Azure DevOps).
- One use case for including children is if your work item is an Epic and you want to also measure the completion of User Stories that are linked as children to that Epic. If including any children of the work item it will bring back the first immediate child of the selected work item.
Tip: When you are searching for work item names, make sure to search for entire words within your work item names to bring up search results.
- WorkBoard will gather the count of Work Items in the query. The count will be total number of work items slated for completion during the OKR time period.
- You can select the set of statues associated with work items that are considered completed work in your project and workflow. Completion percentage for these key results will be based on the total number of work items in the query, and how many of them are considered "Done" based on your selections.
Tip: You will want to select queries that pull items from a single project; especially if you have different custom statuses defined per project.
Status selection when configuring a key result is based on the custom statuses defined for the one project you select in the key result creation workflow.
Synchronizing Data from Azure DevOps
WorkBoard will pull data for the KR directly from Smartsheet following the cadence specified. The Business Result Owner also has the ability to “sync data now” to pull data in real-time.
There are two ways to sync data for your Key Results.
Force a Sync on a Single Azure DevOps Key Result:
- Select Key Result to go to the Key Results Details page.
- Choose the Kebab menu in the upper right-hand corner.
- Select Sync Integration Data.
Force a Sync for all Key Result Integrations:
- From the My Objectives Page, select the Kebab icon in the upper right-hand corner.
- Select Sync Integration Data.