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}}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.