Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Does anyone use the Smartsheet connector for Jira?

I've recently started using the Smartsheet connector for Jira and writing a use case. Has anyone else used this? I'd be interested in hearing information and experience if anyone has anything to share.

6 answers

The Jira connector does work, but can be a pain to use, as you can see from other people's comments here too.

I also don't remember seeing any enhancements or roadmaps for the Connector itself, so not sure how committed Smartsheet is on this tool. 

If you are not tied to Smartsheet, explore the Google Sheets <> Jira integration too.

I can imagine that Google probably has a better integration tool, but I find Smartsheet WAY easier to use for building a project plan than Google docs. Thanks for the suggestion thought!

@Lydia M - Definitely listen to @Neeraj he taught me everything I know :) 

(Hey @Neeraj, how you doin'?)

Lol.. Hi Mike. You are being modest. All I did was introduce it to you, and away you ran with it. 

BTW.. we learnt some hard lessons... you CANNOT assign or make somebody else the owner of a Connector workflow, and they have to be recreated from scratch. Was not fun doing those :-( 

Like Mike Hayes likes this

Watching this one for sure. Lydia would you mind sharing the link of the specific app you're using? I'd like to learn more about it. Thank you!

Hi Martha, 

We primarily use Smartsheet for project plans at my company, so at some point someone got this connector that Smartsheet offers.

It's been pretty good so far, but it has taken a bit to get it to work consistently. My use case is full of "tried this--didn't work, tried that--didn't work" lol!

I have used the smartsheet connector to create reports for teammates to track progress on their requests that do not have access to Jira.

Scenario: 

We receive requests from other divisions, but these teammates do not have access to Jira to track progress of these requests. I've created filters that provides the information that they (requester) are interested in, pull that filter into a smartsheet using the connector, and then save these reports in a sharable location. When the end user opens the smartsheet, the filter is triggered, giving them up to date information each time they open one of the reports. This keeps us from using up Jira seats for users who would only need read access, but still allows us to share important information with them regarding their requests.

Hi Coby,

Thank you so much for sharing! I hadn't thought about this application of the connector yet. I was mainly focused on updating Jira issues from a Smartsheet project plan, but creating reports from Jira would be useful and plan to add this to my use case! :)

Yes, We use it a lot. It can be a little clunky, but it does work. Are there specific questions regarding the connector?

We use it so that our Professional Services team can Add a Row of something that our Development team needs to do so it creates an issue for the Dev team to work and as they update their Progress, Status and estimated Delivery dates flow to Smartsheets to keep PS Updated so they can inform clients.

We opted not to get the Smartsheet connector (largely due to cost) and also because we have Workato, an awesome integration application that we use across the company for all sorts of integration. We're working right now to integrate Jira and Smartsheet using Workato so it's still in the early stages but so far it seems like it will work pretty well for us.

We use Boomi as our integration platform and that works really well. However, Jira & Smartsheet's API leave a lot to be desired (IMO). So the Connector handles our Use Case really well. However, the Connector does have several limitations; Like one sheet can only connect to 1 project. So if you have multiple Jira Projects to connect to, you'll need separate sheets with their own connection logic. This works well for us so that it forces our Professional Services team to ensure they are adding work to the Right sheet so the proper Dev team gets the work, Rather than everything going into a "Catch All" and asking Dev Operations to sort it all out. 

Ryan - You actually CAN connect multiple Projects to a single sheet. We have used it this way successfully for a while now.

Like Mike Hayes likes this

I have found that while you can have a Smartsheet that connects to multiple Jira projects, you can only create one workflow/connector per Smartsheet.

For example, in my Smartsheet, I have Development issues syncing to DEV Jira project, AUDIO issues syncing to that Jira project, and QUALITY issues syncing to the QA Jira project. But I can only have one connector for that sheet. 

@Lydia M - "tried this--didn't work, tried that--didn't work" is exactly how it goes! I've used it extensively. Here are some tips n' tricks...

1. You cannot update Assignee via Smartsheet unless the user has their account settings configured appropriately.

2. "Save as new" is your friend. Every so often, save a copy of your sheet since it's easy to overwrite data when troubleshooting your connector.

3. End date cannot (mostly) be synched. If your Smartsheet plan has dependencies enabled, you can only sync End date (or whatever your plan's end date is) from Jira -> Smartsheet.

4. If you close a ticket in Jira, and your connector filter rules say "don't synch items that are closed," then it won't update Smartsheet with the correct Jira status.

5. Smartsheet does not understand Jira hierarchy beyond Epic. So, if you have a Jira hierarchy defined as Initiative -> Epic -> Standard Issue -> Sub-task, then Smartsheet won't know how to cleanly handle the Initiatives (there's a trick, but it's not pretty).

6. If you specify a Smartsheet hierarchy other than Epic -> Standard issue -> Sub-task AND you want to be able to create new issues from Smartsheet, then the PRIMARY Smartsheet column MUST be Key (Jira key/issue ID).

7. Smartsheet connector does not support two-way synch of cascading select lists.

8. You need to make sure the fields you want to connect are visible on the Create and Edit Jira screens.

9. Although it's allowed, I would absolutely not connect two sheets to the same project/set of issues. You'll get each one constantly updating with the other and it will make you crazy.

10. Name your Smartsheet columns with something that indicates if it's synched so users know. For example, instead of "Summary" name it "Summary ->" for fields that update from Jira to Smartsheet, and name it "Summary <-" for fields that update from Smartsheet to Jira, and name it "Summary <->" for fields that update in both directions.

Now here is a guy who really knows this inside out :-)


Hi Mike. Nice to see you here. Small world :-)

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you