I cannot get the jira connector to work

clawson ✭✭

06/20/23 edited 06/21/23 inAdd Ons and Integrations

I have a business account. I am an Admin in Jira. There is nothing telling me how to connect. When I click on connect it tells me to contact SmartSheet. I had an account manager. Cant find his name. Can't seem to put in a support ticket either.

0 ·

Best Answer

Genevieve P. Employee Admin

06/21/23 Answer ✓

Hi@clawson

The Jira Connector would need to be purchased in addition to your Smartsheet plan. If your plan doesn't include this connector, you can contact theSales team from this page.

Here's more information:Smartsheet for Jira Connector: Overview

Cheers,

Genevieve

0 · Share on Facebook Share on Twitter

Answers

Genevieve P. Employee Admin

06/21/23 Answer ✓

Hi@clawson

The Jira Connector would need to be purchased in addition to your Smartsheet plan. If your plan doesn't include this connector, you can contact theSales team from this page.

Here's more information:Smartsheet for Jira Connector: Overview

Cheers,

Genevieve

0 · Share on Facebook Share on Twitter

Categories

You would need to use a Move Row or Copy Row automation.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":106686,"type":"question","name":"Creating a form with multiple entries","excerpt":"Hi, So my issue is, I have a form that is designed to record incoming invoices. I need the form to firstly attach a number of invoices and create multiple entries. I've seen some ways to do this using another sheet and automation. The only problem with this is the form has to have pdf uploads of the invoices. So I'm not…","categoryID":321,"dateInserted":"2023-06-21T12:49:14+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T09:36:48+00:00","insertUserID":162427,"insertUser":{"userID":162427,"name":"Zachwalters99","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Zachwalters99","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T09:39:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162427,"lastUser":{"userID":162427,"name":"Zachwalters99","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Zachwalters99","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T09:39:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":27,"score":null,"hot":3374866562,"url":"https:\/\/community.smartsheet.com\/discussion\/106686\/creating-a-form-with-multiple-entries","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106686\/creating-a-form-with-multiple-entries","format":"Rich","lastPost":{"discussionID":106686,"commentID":381901,"name":"Re: Creating a form with multiple entries","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381901#Comment_381901","dateInserted":"2023-06-23T09:36:48+00:00","insertUserID":162427,"insertUser":{"userID":162427,"name":"Zachwalters99","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Zachwalters99","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T09:39:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T09:30:18+00:00","dateAnswered":"2023-06-21T16:49:39+00:00","acceptedAnswers":[{"commentID":381537,"body":"

Hi @Zachwalters99<\/a> <\/p>

I hope you're well and safe!<\/p>

I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.<\/p>

Would that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

@isabonita<\/a> is on the right track. This is kind of an involved answer, but once you figure out the logic, it isn't that bad.<\/p>

You cannot reference specific cells in the conditional format in a manner that would make this easy. You cannot, for instance, say IF this specific cell is greater than that cell, apply this format. You can do it for the same row, but not always referencing the same cell. We get around this by inserting a \"helper\" column for each condition we want to check. The checkbox format works great. In the conditional format rule, you can simply say IF THIS cell is checked, apply the format to THAT cell. <\/p>

To set the checkbox to checked\/unchecked, we use this column formula: =IF(PDP@row > PDP#, 1, 0)<\/p>

But what is PDP#? This is another issue we have to work around. You cannot reference the first cell of a column in a column formula, you can only reference cells in the same row. To work around this, we add fields into the sheet summary. [PDP]# references the PDP field in the sheet summary. In order to make updating these values easier, we set the value of this field equal to the first cell in the PDP column using =PDP1<\/p>

After creating all of the helper columns, setting up the column formulas for each to determine which ones are checked, creating all of the necessary fields in the sheet summary, and setting those equal to the first cells in each of the respective columns within the sheet, we can set up the conditional formatting.<\/p>

Check out the image below to get an idea of how to setup the formats. Unfortunately, we have one more workaround to setup at this stage. Since the formatting will apply to every row in the sheet, it will apply to the first row as well and all of those cells will be green. To get around this, add the first format pictured below as the first one in your list. For the background color, you must select \"white\" in order to avoid the highlight. If you set it to \"no background\", you will get an error because Smartsheet does not see \"no background\" as a format.<\/p>

After everything is setup and running, you should be able to update the cells in your target row and things will work themselves out automatically.<\/p>

<\/p>

\n
\n \n $\"Condition.PNG\"$ <\/img><\/a>\n <\/div>\n<\/div>\n
I hope this helps, and I really hope it makes sense.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5399,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">