Custom field comparing two dates and providing color/status indication

Yaniv L

I have 2 projects and issue between those projects are related (parent or linked issues)

Issues from each one of those projects can have Fix version (with due date).

I have add a formula field to show the version due date.

Is it possible to:

• Color the "Version Due Date" if 1 of the related items' due date is after the parent due date?

or 

• Add a another field that will compare the dates and present color / text indicating one of the related is after the parent's due date?

Working with Data Center.

Stepan Kholodov

Hello @Yaniv L 

For example, you can use a formula like this:

if issuetype = "issuetype_name" and (version.releasedate < max#children{version.releasedate} or
version.releasedate < min#children{version.releasedate}): ":panel[Children released later]{color=#FFFFFF backgroundColor=#BF2C34}

where issuetype_name is name of the type of CR-50. The format of the column should be set as Markdown.
The formula will return a text indicator on a colored background if any of the sub-issues Release dates of their versions are later than the Release date of the parent's version Release date.

I hope this helps. If you have other questions, please reach out to us directly at our support portal and we'll get back to you shortly.

Best regards,
Stepan Kholodov
Tempo