We use a standard project plan (~100 tasks/steps) as a template for our team, and it gets copied for each new project. There are ~6 tasks on the project plan that drive Jira task ticket creation. Instead of adding extra columns to the standard project plan sheet (since they'll be blank for most rows), we link the task on the standard project plan sheet to another SmartSheet, where the user selects/completes the details needed for the Jira ticket. The 2nd SmartSheet is shared/linked to all the project plans (master/aggregated sheet), so that we have a centralized sheet with all the Jira requests/status updates in one place for ALL projects.
What I'm trying to figure out is a way to auto-link/auto-update from the centralized Jira sheet of ALL projects, back to the specific project plan (please see image below).
Is this possible? Or is there another way to accomplish something similar without having to recreate the workflows every time we copy over the standard project plan to use with a new project?