Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Jira Structure - Formula Column "TYPE?" Error


Need assistance with Jira Structure Formula column.

I have built out a Jira Dashboard made up of a number of Structures. The last column of all of my Structures is a Formula column I am using to track fixVersion.ReleaseDate as compared to targetend and duedate and return text values of overdue, on track, or past desired date. I have success for a mjority of the Story and Task issues I am tracking but for others receive a "TYPE?" error.

It should be noted that ALL Jira issue types of Story and Task have:

  • A Fix Versions
  • Due Date or Sprint

assigned to them.

I do not see a difference between a Story that updates the Formula properly and one that give the error.

The formula I am using is below:

IF (

(issuetype = 'Story' OR issuetype = 'Task')AND targetend = undefined and duedate >= DATE('2022-01-01');

iF (

duedate > fixVersion.ReleaseDate, ":panel[OVERDUE]{color=red}",

duedate <= fixVersion.ReleaseDate, ":panel[ON TRACK]{color=blue}"




IF (

(issuetype = 'Story' OR issuetype = 'Task')AND targetend >= DATE('2022-01-01');

iF (

targetend > fixVersion.ReleaseDate, ":panel[Past Desired Date]{color=red}",

targetend <= fixVersion.ReleaseDate, ":panel[ON TRACK]{color=blue}"



IF (

(issuetype = 'Story' OR issuetype = 'Task');

if (

duedate = undefined and targetend = undefined, ":panel[Need Sprint or Due Date]{color=orange}"



Here is a screen grab of the error I see for some of my rows:

Jira Type Error2.jpg

It should be noted there are no errors in my Formula per the below pic:

No errors.jpg

Any thoughts?

1 answer

1 accepted

1 vote
Answer accepted
David Niro _Tempo_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 10, 2023 • edited

Hi @Brian Lehmbeck ,

Posting here as well in case others are looking for similar information.  Thank you for working through this with me!  As you identified, the reason the formula was throwing the error was due to there being more that one fixversion on some of the issues.

We were able to resolve this by using a unique identifier from the to FILTER() the ones we wanted.

We also used Local Variables to move some of the repeating conditions outside of the nested IF statements to come up with: 

with _releasedate = fixversion.FILTER($.name.LEFT(4) = "LCUS").releasedate:

with _issuetype = 
    IF issuetype = "Story" OR issuetype = "Task":

with _condition1 =
    IF _issuetype = "true" AND targetend = undefined and duedate >= DATE('2022-01-01'):

with _condition2 =
    IF _issuetype = "true" AND targetend >= DATE('2022-01-01'):

with _condition3 = 
    IF _issuetype = "true" AND duedate = undefined AND targetend = undefined:

IF _condition1 = "true" AND duedate > _releasedate:
ELSE IF _condition1 = "true" AND duedate < _releasedate:
    ":panel[ON TRACK]{color=blue}"
ELSE IF _condition2 = "true" AND targetend > _releasedate:
    ":panel[Past Desired Date]{color=red}"
ELSE IF _condition2 = "true" AND targetend <= _releasedate:
    ":panel[ON TRACK]{color=blue}"
ELSE IF _condition3 = "true" :
    ":panel[Need Sprint or Due Date]{color=orange}"


Thank you for all of your help David!

Like # people like this

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events