Creating Logic in a Form
I am new to the development of forms. My team currently has a form which collects weekly hours spent on assigned projects. Each member of the team opens the form selects their name and the specific project then provides the additional information requested.
Is there a way using Logic that once the individual selects their name only the projects they are assigned to appear in the list of project instead of having to view a list of all projects for the team?
Project assignments can change each week and several individuals can bee assigned to the same project.
Could there be two additional columns added to the sheet the form is linked to. One column could be titled Active Projects and listed all open projects. The other column could be titled Assigned and displays mulitiple individuals assigned. Then when the individual selects their name in the form the Assigned column is "sorted" by their name and the Active Projects column then displays only the projects there are assigned to which then carries over to the form. This is similar to a Data Validation dependent dropdown list in Excel.
I would appreciate any help regarding this question.
I have reviewed the article on "Using Conditional Logic to Streamline Form Submissions".