Form selection of dropdown list inserts choice with hyperlink

We have a project management Smartsheet where we have about 3 different "standard work" choices - these are selections where the requirements are the same each time. This list may grow later.

On our request form, I'd like the user to be able to select from the selection of 3 different "standard work" choices, and in the project management sheet, a hyperlink be inserted to the standard work specs outline.

Would need it to allow for multiple entries in one cell, each a different link.

Open to totally different suggestions as well!

For example:

(on the request form)

Standard Work?

3D render 360s

3D render Hero Shot

(in the Smartsheet)

Standard work requested: 3D render Hero Shot (link to specs), 3D render 360s (link to specs)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!