Form Drop Down Populated by Separate Sheets?
Is it possible to connect a drop down column in a sheet to another sheet as a lookup for relevant values? This would enable centralized control of values ensuring they are accurate for form submission. Looking at articles on Data Uploader, this would be too powerful for the specific use case below.
Obj: Users are only able to request features/enhancements to active projects.
Form field would be populated via a lookup to a separate sheet which pulls only active projects based upon the portfolio summary. As projects complete or are added the "active project sheet" would be dynamic and update, thereby altering the choice selections available for users in the form.
Help Article Resources
Check out the Formula Handbook template!