Bill Sheboy

Smart values are name, spacing, and case sensitive. When in doubt of the smart value for a field (or if a field is even supported) please try this how-to article. Essentially you identify an example issue with your field, call the REST API from a browser, and search for your field on the page to learn its smart value.…

in Automation: Create new task with incremented custom field after another task is transitioned to done Comment by Bill Sheboy February 2023

Hi @Emre Toptancı _OBSS_ and @John Funk I noticed you have some extra curly brackets in the expressions...once inside of the brackets the other ones are not needed. For example: {{now.plusHours(someVariable.asNumber)}} Please note that I assumed use of a variable, and so converted from text to number type. Next, round()…

in Jira Automation: Can't use the result of a math expression to calculate a date Comment by Bill Sheboy February 2023

Hi @Marina Shelestiuk Adding to Trudy's suggestions... Would you please post an image of the audit log details showing the rule execution? That may provide more context for what is happening. Thanks! Kind regards, Bill

in Sum up story points in epic Comment by Bill Sheboy February 2023

Hi @Nataliia Kriuchkova Using the browser translator, I see you want to detect specific tags in your automation rule, and then send an email. What do you mean by tag? Do you mean the Labels field? If so you could use a condition test to determine if one (or more) Labels exist and then send the email. And if you are just…

in отправка уведомления на е-мейл по точному лейбу Comment by Bill Sheboy February 2023

Hi @Admin acme-deepcred Yes, and...to Vikrant's answer, here is the documentation for calling that function: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-projects/#api-rest-api-3-project-projectidorkey-get Kind regards, Bill

in Using the API to tell if a jira project is team or company managed Comment by Bill Sheboy February 2023

Hi @Ethan Ferguson Would you please post images of your complete rules. That may provide context for the symptoms you are observing. Thanks! And...changing the issueType of something is not a trivial thing...which is why the UX has a specific function and code (i.e. Move) for this operation. I find it likely that when…

in Unable to have automation-created Stories include the epic link of the trigger issue Comment by Bill Sheboy February 2023

Hi @Kasper Ramstafer -- Welcome to the Atlassian Community! Adding to Mark's answer... There are built-in math functions for add, substract, etc.: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/ So you could also use {{triggerIssue.annual.plus(1)}} Kind regards, Bill

in Automation: Create new task with incremented custom field after another task is transitioned to done Comment by Bill Sheboy February 2023

I just noticed in this rule... Things like .jiraDate help with formatting the output. I would recommend not using them to set an actual date or date/time field. One or more of the human-readable formats could product an ambiguous value if a rule or JQL tries to use it later as a date.

in Automate End date of an issue from Original Estimate & Start Date Comment by Bill Sheboy February 2023

Hi @Thies Uhlenbruch Created variables are text type, and so must be converted with .toDate before using the date/time functions with them. Kind regards, Bill

in Check if {{now}} is a business day - Smart values Comment by Bill Sheboy February 2023

Hi! The math operators only operate on number and date values, and created variables are text. Please try adding .toDate so your variable is converted in the comparison's functions, such as this: {{#if(and(issue.customfield_10307.gte(Allerheiligen.toDate), issue.dueDate.lte(Allerheiligen.toDate)))}}true{{/}} Also, what is…

in Can we reach to the non-working days from the Jira board via automation? Comment by Bill Sheboy February 2023

Hi @Marina Shelestiuk I believe it is possible to create a rule to handle changes for either the subtasks or stories/tasks/bugs...and that approach is probably better than using two rules. One way to do this is using if/else condition blocks, and then branch to the appropriate issues, as needed. I recommend creating a test…

in How sum up story point estimate in Epic from stories and others tasks? Comment by Bill Sheboy February 2023

I am glad to learn that helped. If you are unable to add your condition using JQL, it may be possible to also add it using smart value, list filtering: https://community.atlassian.com/t5/Automation-articles/Filtering-smart-value-lists/ba-p/1827588

in Jira automation & issue list & date.diff Comment by Bill Sheboy February 2023

Hi @Amed Moreno Are you trying to get a list of completed sprints for a single issue, a collection of issues, something else? To get what you described for a single issue, that has been in multiple sprints, please try this using an iterator over the sprint list field: {{#issue.sprint}}{{name}} ended…

in How do I combine 2 string smart values in jira automation advanced edit field section? Comment by Bill Sheboy February 2023

Hi @Rex Parsons Yes and...to Trudy's answer: The only work-around I have found for this gap in admin features is to: * temporarily re-enable the user, * log-in as them from user management, * manage their content as needed, * revert back to admin, and * de-activate them again. Kind regards, Bill

in Editing or deleting a filter subscription owned by someone else Comment by Bill Sheboy February 2023

Hi @Tomas Slavkovsky Interesting...as I believe you have discovered one (and possibly two) defects... First automation defect: date diff() does not appear to work correctly using the smart value order you have tried, even though the documentation shows that should work. If you invert the order it will work as you expect.…

in Jira automation & issue list & date.diff Comment by Bill Sheboy February 2023

Hi @Kit Friend Here are more details on what I described to extract the account id values from the comments... * trigger: issue commented * action: create variable...* name: varAddWatcher * smart value: {{issue.comments.last.body.replace("[~accountid"," [~accountid").split("…

in How to auto-add watcher from the person at in the latest comment? Comment by Bill Sheboy February 2023

Hi @Chloe Davies -- Welcome to the Atlassian Community! I recommend not doing what you described in scenario #2 (i.e. splitting items). Instead consider just letting the items carry over, and during the team retrospective discuss what was different/special about the work that led to it not finishing, and perhaps what could…

in How to handle transparency around carry forward JIRAs? Comment by Bill Sheboy February 2023

hi @Rudy Holtkamp I believe that is only possible with the REST API from a rule. Here is a suggestion to add a delete action for rules: https://jira.atlassian.com/browse/JSWCLOUD-22628 Kind regards, Bill

in Delete Jira issue property via Jira Automation Comment by Bill Sheboy February 2023

Hi @Marina Shelestiuk -- Welcome to the Atlassian Community! My original post had a typo in the JQL, and should have been checking if parent = {{triggerIssue.parent.key}} when the trigger issue is a story (or task or bug). Please try that to see how it helps. Thanks! Kind regards, Bill

in How sum up story point estimate in Epic from stories and others tasks? Comment by Bill Sheboy February 2023

Hi @owen heggen -- Welcome to the Atlassian Community! To do that I believe you can use a web request from the rule to call the BitBucket REST API and check if exists first. Here is a how-to for calling a REST API from a…

in Jira Automation Bitbucket branch exist condition - Transition trigger Comment by Bill Sheboy February 2023

Hi @Keith Vedol I have not sent a message to Slack from a rule for a while, so I suggest looking at the bullet syntax for Slack...and then split your issue description on new lines and iterate, adding the bullet indicator to the front to see what happens to the Slack message. Kind regards, Bill

in Bullet formatting issues with Slack messages being sent with Jira automation rule Comment by Bill Sheboy February 2023

It seems to be missing the period between the time zone change and the plusMonths().

in Automation rule to schedule monthly, yearly, bi-yearly, quarterly tasks based on time. Comment by Bill Sheboy February 2023

Hi @Jason Weddell I have observed time zone impacting date/time operations for Jira automation rules...even when all participants are in the same zone. Perhaps try forcing the values (actualstart and now) to the same zone before incrementing, formatting, and comparing. Kind regards, Bill

in Automation rule to schedule monthly, yearly, bi-yearly, quarterly tasks based on time. Comment by Bill Sheboy February 2023

Hi @Cary Lewis Maybe...but not as how you describe it... A board is a view of issues in a project based upon a filter. Automation rules cannot know about the "board" but you could determine if an issue matches a filter for a particular board, and take actions as needed. IMHO: this is a risky rule unless your rule…

in Is it possible to create an automation based on which board an issue is being created on? Comment by Bill Sheboy February 2023

Thanks for clarifying, Dillon. The outcome you note is a common case...it is the details where it gets interesting implementing with rules. My recommendation would be to first try to answer the questions below to understand how many rules you need and what triggers could fire them. Then try doing this incrementally in…

in How to automatically link issues based on field in related epic Comment by Bill Sheboy February 2023

Some things to note... * Create variables (and even some issue fields) appear not to work in all possible functions. * And...smart value, list filtering has the same challenge, as you can read in the comments to this article: https://community.atlassian.com/t5/Automation-articles/Filtering-smart-value-lists/ba-p/1827588 *…

in access a created variable's value (from a list), using it in a function...within an iterator Comment by Bill Sheboy February 2023

Hi @Thies Uhlenbruch I do not have an example rule for this as I am unclear of what your scenario is. Perhaps consider adding a new question and linking to this one for context. An example advanced compare condition to test a range would be: * first value: {{#if(and(issue.some begin date.gte(holiday date), issue.some end…

in Can we reach to the non-working days from the Jira board via automation? Comment by Bill Sheboy February 2023

Hi @David Pezet No, I did not. Created variables are still just text, with no structure. The closest I have gotten to this was to use a homemade, delimited variable and then a match() function later to process it. Here is an example of that technique to find the latest sprint an issue was…

in access a created variable's value (from a list), using it in a function...within an iterator Comment by Bill Sheboy February 2023

Hi @Sagi Gueta Adding to Trudy's questions/ideas... This is configured as a multi-project/global scope rule, and so I wonder about consistency of the issue types and status values across the projects. Regardless of that... Please show the audit log details for a case where you believe an email was sent when the number of…

in Lookupissues not working as expected Comment by Bill Sheboy February 2023

Hi @Thies Uhlenbruch With the current capabilities/limitations of using created variables in rule functions functions...the only possible work-around I have found for this was chaining math conditions of greater than or equal to (gte) and less than or equal to (lte) on the…

in How to calculate business days including Bank Holidays? Comment by Bill Sheboy February 2023

Bill Sheboy Expert

Comments