Google sheets “dropdown list” of two separate ranges for the list and the validation

Ολοκληρωμένο Αναρτήθηκε Mar 11, 2016 Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

I have a google sheets spreadsheet and I am trying to create a dropdown list working with two seperate ranges for the list and the validation.

Suppose I have named ranges "ALLprojects" and "OPENprojects". "OPENprojects" are created automatically with a FILTER formula, if the projects are indicated "closed".

I would like to have a dropdown list for the entire column A, showing only "open projects", but the entire column needs to be validated with "all projects"

I think this can not be done with the built-in data validation feature, which looks at the same range for both the list and validation. I am hoping a script would work.

Do you know any script would do this?

I have created a sample sheet and link is below: [login to view URL]

Excel Google App Engine

Ταυτότητα Εργασίας: #9917081

Σχετικά με την εργασία

4 προτάσεις Απομακρυσμένη εργασία Ενεργό Mar 11, 2016

Ανατέθηκε στον:

bytessolution

Greetings. I specialize in provide solutions for Business Administration, Data Base management, Key Performance Indicators design, Supply Chain Planning and Project Management for commercial and industrial companies. Περισσότερα

$19 USD σε 1 μέρα
(159 Αξιολογήσεις)
6.9
Imelda7s

Hi, Please award me this bid. I can create a drop down list immediately. Is the google sheet shared for editing? Thanks,

$10 USD σε 1 μέρα
(2 Αξιολογήσεις)
0.8

4 freelancers κάνουν προσφορές κατά μέσο όρο $16 για αυτή τη δουλειά

guillenjr842

Hi, I had a similar problem with a inventory spreadsheet, is a simple formula. I can doit for today.

$10 USD σε 10 μέρες
(2 Αξιολογήσεις)
2.3