New to Jira. Checklist in Google Sheets with dates that auto populate.

[Dawn Zarcaro]

We currently use a google sheet for each project that auto-populates with dates for 60 items that happen for each project. Each project starts the same way. Is there a plugin for Jira that would be similar to this method of tracking? 

Or do you have a suggestion on how to best use Jira to do something similar? 

[Earl McCutcheon · Accepted solution]

Hello @Dawn Zarcaro ,

You could look into using Automation for Jira which is a built-in front-end feature, that can be used to run calculations via "Smart Values".

The following documentation details how Date values and calculating math functions work using these Smartvalues to auto-populate the desired date values:

• "Smart values - date and time functions" 
• "Smart values - math expressions" 

and the Automation Getting Started material at the following link for a reference point for additional details:

• https://support.atlassian.com/jira-software-cloud/docs/automate-your-jira-cloud-processes-and-workflows/

As described in the documentation you can increment a date value using a smart value in the format:

{{[date].plus[Unit]([number])}}

Please check out the articles and let me know some more about how you are trying to add and increment the date values and I can help formulate the layout.

Regards,
Earl

[Danielle Bonneau · Accepted solution]

Hi Dawn, you could look at using the Jira Automation feature to do this.  

If you were to have each of those 60 items be a ticket, you can use Jira Automation to not only automatically generate those tickets, but also to set a Date field (like Date Due) using the date/time Smart Values: https://support.atlassian.com/jira-software-cloud/docs/smart-values-date-and-time-functions/. For example, you could manually trigger the creation of a ticket, and then as part of that automation, set the Date Due to be now + 5 business days.