Integration to MS Azure Devops (i.e. TFS)

Yoav Simple · 01/21/21

I want to integrate Smartsheet data to and from Azure Devops, both ways.

What is the best way to do that?

JeremiahHorstick · 01/21/21

Did you see this discussion?:

Integration with DevOps

Mar 26, 2020

I'm looking for some help setting up my integration from Azure DevOps to Smartsheet. Anyone have experience with that integration?

Microsoft references a connector via Logic, Power Apps, And Power Automate: https://docs.microsoft.com/en-us/connectors/smartsheet/

I'm sure those Microsoft Tools have DevOps methods as well...

JeremiahHorstick · 01/21/21

@Yoav Simple

Sync it! ... Just Kidding. 😄

What data?

Yoav Simple · 01/21/21

@JeremiahHorstick I'm on it haha

The goal is to have high level tasks in Smartsheet, and low level dev tasks in Azure Devops.

Tasks from Azure can be nested to Smartsheet under existing rows with all associated data (e.g. status), and/or aggregated by specific data (e.g. working hours) to display as summary KPI in a Smartsheet sheet.

I'm not sure about the full specs, but at this stage I mainly want to understand if and how is that even possible- via a native Smartsheet integration? or perhaps a 3rd party app (e.g. Zapier)?