Sign in to submit new ideas and vote
Get Started

Data Validation Dropdown Lists - Simple Feature

I would like to make a list of all my organizations open projects on one sheet, then use that list for a "Dropdown List - column" on multiple other sheets so that the user can select the correct project from this list rather than enter it in free-hand (without reference). The "dropdown list" must be updated automatically based on the sheet containing the source list. This is easily achievable in excel via the Data Validation - List menu item. Alternatively, you may want to add "Lists" as a document type so that these lists can be selected on the "column properties" context menu from the user's stored documents.

As always, I am not requesting an idea for a convoluted work-around. It's a simple feature and I hope you consider a quick update to accommodate it. Thanks.

6 votes

Idea Submitted · Last Updated