Auto-populate multiple cells with hyperlinks to web pages based on the value of one cell?
I have a sheet serving as a software upgrade checklist template "model", (not an actual template, because it contains cross-sheet functionality, which is lost in templates).
The sheet includes rows of tasks and a column containing hyperlinks to web-based instructions for each task.
Instructions are on different pages based on the version of software being upgraded. I'd like to make a drop-menu cell listing software versions, and populate the hyperlink/instructions cells based on the version selected in that cell.
The user would select the sheet, "save as new...", then select the software version from the version menu cell, and the sheet would auto-populate with the appropriate hyperlinks.
Is this possible in Smartsheet?
At all cost, I want to avoid making a sheet for each software version.
I'm considering making a separate sheet containing ALL links for ALL software versions, and using vlookup, but I'd rather not, if there's an easier way.
I hope this makes sense.