Auto-hyper-link a sheet generated using template


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!


  • Julio S.
    Julio S. Moderator

    Hi @manabu,

    There is currently no possible way in Smartsheet to auto-generate hyperlinks in the way that you are intending, when you have a moment, please let our Product team know about your feedback by filling in this form, here. Thank you! 

    It seems that you are trying to automate the process of provisioning projects and possibly gather metadata about each of these while keeping all the project information inter-connected. This is precisely what Control Center does. If this sounds like a possibility, you may want to reach out internally within your organization to check whether you can get access to this tool.

    I hope that this can be of help.



  • manabu
    manabu ✭✭

    Thank you for response. I am trying without control center but looks like this is the limit. Thank you!

    Thank you,


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!