Google sheets “dropdown list” of two separate ranges for the list and the validation
$10-30 USD
Teslim sırasında ödenir
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]
Proje NO: #9917081
Proje hakkında
Seçilen:
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. Daha Fazla
Hi, Please award me this bid. I can create a drop down list immediately. Is the google sheet shared for editing? Thanks,
Bu iş için 4 freelancer ortalamada $16 teklif veriyor
Hi, I had a similar problem with a inventory spreadsheet, is a simple formula. I can doit for today.
