Object Calculated Field

Christian
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 12, 2025

I have an asset object that has an expiration date field. I would like to have a calculated field that always equal the number of days between now and the expiration date. Is there a simple slick way to do this? 

1 answer

1 vote
Calvin
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 12, 2025

Interested to know any suggested answers as well.

Currently the only way I can see this happening is by running an automation daily (say 9am) that runs through all these objects and re-calculates the number of days. And maybe another one on update for the specific object to get the initial instance.

As far as I know there isn't a way to have one field dependent on another, though I know our team is interested in this too. Eg. having one field be 1 year after another field.

If you are using an automation, this page may help:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

Particularly the "Date difference" section:

{{now.diff({{object.variable.date}}).days}}

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events