Fields that I have been pulling from Jira into my project sheets are no longer appearing in the "Add Fields" drop down menu on the "Map Jira fields to sheet columns" in new workflows. I don't know what happened or how to get them back.
Hello,
For fields to be available for use in the Jira Connector, those fields must be present within the Create and Edit Issue Screens in your mapped Jira Projects. If you were using those fields before but they aren't appearing in any Jira Connector Workflows now, it's possible a Jira Admin made changes and removed those fields from the required Screens.
You can read more about editing Issue Screens here: https://confluence.atlassian.com/adminjiraserver/defining-a-screen-938847288.html
If that doesn't seem to explain this, please reach out to Smartsheet Support and we'll be glad to help! You can reach us at: https://help.smartsheet.com/contact
If you need assistance from Smartsheet Support, I'd recommend including the following information when writing in to ensure we can get a solution for you as quickly as possible:
Hope that helps!
Best,
Nathan
Solution:
1) Create a JIRA Project that pops up as the first JIRA Project in your Production Environment (ex: AAAAA Smartsheets Connector"
2) Within 1 issuetype, doesn't matter, add all needed fields to the 'Create' & 'Edit' Screen.
This solution worked for my company
I cannot for the life of me figure out how to get the overdue which is in a date field in red text, counted on multiple sheets and only if its not complete, or not cancelled - everytime we try, it get 0 which is inaccurate =COUNTIFS({Exp_Status}, <>"Complete", {Exp_Due}, <TODAY())
Hi, I have an existing filter comprised of 6 predicates which all have to be true. I want to edit this filter to add a predicate (to make 7), but I only seem to be able to remove a predicate, not add one. Can anyone help please? Thanks, GAM
Quick Question; Is there a way or work around in automation such that when a child task is past due, the parent task status can move to "At Risk"? Seems like something that should be simple, and maybe it is, but I'm not able to develop a work around. Thanks in advance.