Sign in to submit new ideas and vote
Get Started

Dynamic drop down lists on Forms/Sheets

We have one sheet (our project intake list with form) with a list of projects and includes project title, project manager assigned, start dates, end dates, project status, etc. that is updated often and will include new projects as well as status of any in progress or completed projects. We have another sheet/form that we use for Project/PM Surveys that we have to manually add/remove projects and project manager names on depending on if they are new or completed. It would be nice for that sheet/form to be auto-updated based on logic/criteria from our project list sheet so we don't have to manually update the sheet/form for the surveys.

Tags:
2
2 votes

Idea Submitted · Last Updated