Google sheets “dropdown list” of two separate ranges for the list and the validation
$10-30 USD
Πληρώθηκε κατά την παράδοση
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]
Ταυτότητα Εργασίας: #9917081
Σχετικά με την εργασία
Ανατέθηκε στον:
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. Περισσότερα
Hi, Please award me this bid. I can create a drop down list immediately. Is the google sheet shared for editing? Thanks,
4 freelancers κάνουν προσφορές κατά μέσο όρο $16 για αυτή τη δουλειά
Hi, I had a similar problem with a inventory spreadsheet, is a simple formula. I can doit for today.