Hi Smartsheet,
I got a sheet with each project schedule sheet "hyper-linked", like below project A.
If you click project A, a schedule sheet pops-up.
I use data shuttle to generate all the data from other internal data.
Then, using these data, we use a template to generate schedule.
The sheet has index/match formula and other formula so just input a one unique key number to generate schedule data sheet.
When this schedule sheet out of template is generated, i want this sheet to be somehow auto-hyperlinked to summary sheet so it will be displayed in dashboard.
Is there any way to work on this kind of auto-hyperlink triggered by some unique key info?
Thank you for your support in advance!