How can I add table from separate sheet as a dropdown in Project Form sheet?

JT1960 0 Reputation points
2025-02-18T20:49:30.6933333+00:00

I have created a master material list for items needed for different projects. I have also created a form to create a document for each project being worked on. How can I link to two together so that in my project form, the materials list will show up in a dropdown where I can select the items needed and they would be entered in the form. I need to keep the master material list as a table so that new items can be added and show up in my dropdown.Project Form

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,768 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.