Google sheets “dropdown list” of two separate ranges for the list and the validation
$10-30 USD
Pagado a la entrega
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]
Nº del proyecto: #9917081
Sobre el proyecto
Adjudicado a:
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. Más
Hi, Please award me this bid. I can create a drop down list immediately. Is the google sheet shared for editing? Thanks,
4 freelancers están ofertando un promedio de $16 por este trabajo
Hi, I had a similar problem with a inventory spreadsheet, is a simple formula. I can doit for today.