Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Object Calculated Field

Christian
Community Champion
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