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?
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}}
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.