Form list from sheet - help!

I have an intake sheet that has a Project Name column. The list of active projects is kept here. I have a form where I need to let the requestor select which project their request is associated with based on this list of projects.

Is there a way to get that column with the dynamic list of projects to display as a drop down selection in the form for the requestor? Or via a formula? Or in any way where I don't have to manually update the list of projects? Any insight or guidance would be appreciated. Thank you!

Best Answer

Answers