Formula fields library

%{count(filterByIssueType(filterByStatus(subtasks(), "Done, 
Completed"), "Sub-task, Sub-story"))}

%{sum(fieldValue({issue.cfnnnnn},issuesFromJQL("project = DEMO
and 'fieldName' is not empty")))}

%{max(fieldValue({issue.dueDate},subtasks())) != null ? ceil((
min(filterByValue(fieldValue({issue.dueDate},subtasks()),!=, 
null )) - {system.currentDateTime}) / DAY) : null}

%{sum(fieldValue({issue.cfnnnn}, subtasks()))}

issue.changelogs
.filter(changelog => changelog.items
.some(item => item.fieldId == 'customfield_nnnnn'))
.length 

%{issue.labels.length}

%{%{issue.status} = "Open" ? 0 : 
( %{issue.status} = "Planning" ? 15 : 
( %{issue.status} = "In Progress" ? 60 : 
( %{issue.status} = "In Review" ? 70 : 
( %{issue.status} = "Implementing" ? 85 : 100 ))))}

%{count(filterByStatus(subtasks(), "Done, Completed"))} 

%{sum([%{issue.cfnnnnn} = "Option 1" ? 1 : 0, %{issue.cfppppp}
= "Option 2" ? 1 : 0 ])}

issue.subtasks.length && issue.subtasks.map( s => 
(s.customfield_nnnnn || 0) * (s.customfield_ppppp || 0))
.reduce((a, b) => a + b)

%{sum(append(fieldValue({issue.originalEstimate},linkedIssues(
"is blocked by")),[0]))/60} 

 %{{system.currentDateTime} - {issue.created}}

%{sum(fieldValue({issue.cfnnnnn},issuesFromJQL("statusCategory = Done AND 'parent' = "+%{parent.key})))}

%{floor(avg(toNumberList(jiraExpression("issue.subtasks.map(i=>(Number(new Date())-
Number(i.created)))"))))}

%{count(findPattern(%{issue.cfnnnn}, "."))}

%{{issue.cfnnnnn} = null ? null : {issue.cfnnnnn} - sum(
append(fieldValue({issue.cfppppp}, subtasks()), [0]))} 

%{sum(append(fieldValue({issue.timeSpent},linkedIssues("is 
blocked by")), [0]))/60}

%{count(findPattern(%{issue.cfnnnnn}, %{issue.cfmmmmm}))}

%{max([{issue.cfAAAAA}, {issue.cfBBBBB}, {issue.cfCCCCC},
{issue.cfDDDDD}, {issue.cfEEEEE}])} 

%{%{issue.issueType} = "Epic" ? (sum(append(fieldValue(
{issue.timeSpent}, issuesUnderEpic()), [{issue.timeSpent}] ))
/ 60) : null}

%{sum(append(fieldValue({issue.remainingEstimate},linkedIssues(
"is blocked by")),[0]))/60}

%{%{issue.fixVersions} != null ? 
sum(append(fieldValue({issue.timeSpent},
issuesFromJQL("fixVersion = '"+%{issue.fixVersions.id}+"'")),[0]))/60)
: null}

%{{issue.dueDate} != null ? max({issue.dueDate} - 
{system.currentDateTime}, 0) / DAY : null}

%{{issue.resolutionDate} != null ?  (({issue.resolutionDate} - {issue.created}))
: null}

 %{{issue.dueDate} != null ? floor(max({issue.dueDate} - 
 datePart({system.currentDateTime}, RUN_AS_LOCAL),  0) /
 DAY) : null

%{%{issue.fixVersions} != null ? count(issuesFromJQL(
"fixVersion in ('" + jiraExpression( "issue?.fixVersions?.map(
v =>  v?.name).join(\"','\") ") + "') ")) : null}

 %{issue.project.category}

let subtasks = issue.subtasks|| [];
if (subtasks.length == 0){ 'No sub-tasks' }
else{ let doneSubtasks = subtasks.filter(s => s.status.name ==
"Done");
let value = (doneSubtasks.length / subtasks.length) * 100;
let percent =  value - value % 1 + (value % 1 >= 0.5 ? 1 : 0);
let totalBlocks = 10;
let filled = (percent / 100) * totalBlocks;
let full = filled - filled % 1 + (filled % 1 >= 0.5 ? 1 : 0);
let bar = '🟩'.repeat(full) + '⬜️'.repeat(totalBlocks - full);
`${bar} ${percent}%` }

%{{issue.dueDate} = null or %{issue.resolution} != null? "⚪" : 
(addDays({system.currentDateTime}, 14, RUN_AS_LOCAL) < {issue.dueDate} ? "🟢" :
(addDays({system.currentDateTime}, 7, RUN_AS_LOCAL) < {issue.dueDate} ? "🟡" :
({system.currentDateTime} < {issue.dueDate} ? "🟠" : "🔴")))}

%{distinct(fieldValue(%{issue.reporter.displayName}, subtasks()))}

%{distinct(fieldValue(%{issue.components}, subtasks()))}

%{count(findPattern(%{issue.cfnnnnn}, 
"\b(?:https?://|www\.)\S*(?=.*utm_source=)(?=.*utm_medium=)(?=.*utm_campaign=)\S\b"))
= count(findPattern(%{issue.cfnnnnn}, "\b(?:https?://|www\.)\S+\b")) ?
"🟢" : "🔴"}

let minDate = issue?.links.map(link => 
link.linkedIssue.customfield_nnnnn).filter( d => d != null);
minDate.length > 0 ? new Date(minDate.reduce((a, b) => a < b ?
a : b )).toString() : ""

%{matches(%{issue.cfnnnnn},"6|7|8|9") ? "Valid":"Invalid"}

%{%{issue.status.category} = "To Do" ? "🔴⚪️⚪️" : 
( %{issue.status.category} = "In Progress" ? "⚪️🟡⚪️" : 
( %{issue.status.category} = "Done" ? "⚪️⚪️🟢" : 
"⚪️⚪️⚪️" ))}

issue.changelogs.filter(changelog => changelog.items.some(item
=> item.fieldId == 'status')).map(changelog => 
changelog.created).concat(issue.created)[0].toString()

%{issue.project.leadDisplayName}

let minDate = issue?.links.map(link => 
link.linkedIssue.customfield_nnnnn).filter( d => d != null);
minDate.length > 0 ? new CalendarDate(minDate.reduce((a, b) => 
a < b ? a : b )).toString() : ""

%{distinct(fieldValue(%{issue.labels}, subtasks()))}

issue.subtasks.filter(s => s?.originalEstimate == null && 
s?.customfield_nnnnn == null).map(i => i.key).join(", ") 

%{issue.id}

issue.changelogs.filter(changelog => changelog.items.some(item 
=> item.fieldId == 'duedate' && item.from != null)).map(
changelog =>  {duedateentry: changelog.items.filter(item => 
item.fieldId == 'duedate' )}).map(e => new CalendarDate(
e.duedateentry[0].from).toString()).join(", ")

%{%{issue.status} = "Open" ? "🟩🟩🟩🟩🟩"  : 
( %{issue.status} = "Planning" ? "🟩🟩⬜️⬜️⬜️" : 
( %{issue.status} = "In Progress" ? "🟩🟩🟩⬜️⬜️" : 
( %{issue.status} = "In Review" ? "🟩🟩🟩🟩⬜️" : 
( %{issue.status} = "Done" ? "🟩🟩🟩🟩🟩" :
"⬜️⬜️⬜️⬜️⬜️" ))))}

%{distinct(fieldValue(%{issue.assignee.displayName}, subtasks()))}

issue?.comments[0]?.body?.plainText == null ? '' : issue?.comments[0]?.body?.plainText

%{filterByProject(linkedIssues(), %{issue.project.key})}

let reporters= issue.changelogs.map(i=>i.items).flatten().filter(i=>i.field=="reporter");
reporters.length>0 ? 
	reporters.map(a=>a.fromString)[0] == null ?
    	""
        :reporters.map(a=>a.fromString)[0]
:  ""