Linked Sheets for Templates

Gunn_Jack
Gunn_Jack ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I believe this is an enhancement request but I see it is always good here to start the conversation in the community to test the appetite before requesting it, and it seems it gets picked up by staff more here.

I am creating project templates in smartsheets for our project managers. I am doing this by creating a 'Master' sheet as a grid and then converting it into a Template. One I am working on now is a Risk Log.

Part of the Risk Log references another sheet, in order to give a High, Moderate or Low scoring based upon a selection from 1-5 of impact and probability. It is not as simple as saying a total of 2 = low and a total of 10 = high, therefore I need this matrix to determine the level. 

My issue is that I can set up the template on the grid and link this to the other sheet containing the matrix (it would not be appropriate to have them on one sheet) but when trying to convert to a Template it advises the link will not work....hence my request as I do not want everyone using the Master and taking copies as this inevitably somewhere will go wrong. 

Templates are a great tool for PMO's and project managers and I would really like to use smartsheets more for this however would struggle if you cannot link sheets within templates.

I'd be interested to hear if others have experienced this problem and possibly how you have gotten around it if so.

Thanks,

Jack

Comments