using a pull down option from a different sheet

I am looking to use one sheet (risks and issues) which I have created to track my small project risks and issues. I want all of them to be in one sheet as the projects are small and do not require a full risk and issue log on their own. I have another sheet with all of the projects listed in them, i would like to reference the name (title) of the project which the subsequent risk or issue is being logged against - is this possible as a pull down list linked to the project sheet in the risk and issue log?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!