This is helpful, but waaaay more complicated than what I'm looking for. I just need to assign a value to each item on my yes/no/somewhat drop down list. Maybe the previous video is a little simpler. Anyway, I'm glad you have videos like this for reference if ever I need more complicated sheets.
5 лет назад+14
Please make one more video about how to do like that for multiple rows. Huhu.
First of all: Thank you for this excellent Videos. They are fun to learn! One question: I have a 3-Level Dropdown, but not all Data Rows have 3 Entries. So if I choose a row with only 2 Columns, the Validtion for the 3rd Level disappears, but the value of the last selection remains in the cell. How to clear this?
Thank you. If i'll change "make" . Can we make rest of the columns blank. What if we have 2 different data set in different sheet, can we use the same technique?
hello can you direct me to the right video I need if my data list is from column a - and they select an item from the list I want it to show column b c and d in relation to the item they selected - so if a had 15 items and they select the 12th item it will auto fill b,c,d column corresponding to the 12th line - btw thank you for all the help you have provided
Instead of making separate tabs of models and model versions, should be able to put formula into data validation as "Custom Formula is" section thus making it cleaner? Appreciate these tutorials...Thanks and I'm learning.
Hi there how about for multiple rows do you have tutorial with that? Please reply ASAP Make - Model - Verion 1. Honda - HondaM1 - HondaV1 2. BMW - BMWM1- BMWV1 3. Audi - AudiM1- AudiV1 etc. . . .
Sorry this hasn't anything to do with this validation..how can I use upper correctly, and then just keep one column, and if people enter names or whatever the letters become all caps?? Please help with this..
Do you want to force them to enter everything in all caps or do you want to correct what they enter? In case you want to correct, do you want it to become all caps in the cell they type or in a different cell?
@@ExcelGoogleSheets I want when they enter lowercase it automatically turns into all caps, and stays in all caps. Can you help with this. By the way your content is amazing and very helpful.
You'll have to use a script for that. Something like this should work. Make sure you adjust sheet name & column number. function onEdit(e){ var range = e.range; if(range.getColumn() === 2 && range.getSheet().getName() === "Sheet1"){ range.setValue(e.value.toUpperCase()); } }
Yea, that would be very difficult to accomplish, there is no stock functionality to handle anything like that. You need to use a script for that and even then the solution is not very pretty. Why do you feel you need this anyways?
@@ExcelGoogleSheets well, let's say you have the column A with country relation 1-to-1. In the same time you have country set 1-to-many in the column B. I'm stack with column B, as you guess. I'd love to have multi selection from a source of cells for B as for A.
Do you have a video in which a user selects an item from a droplist. Say the item is called "bacon" it will add the $ value of said item to a column? if this helps: I want to make a meal cost spreadsheet to calculate the cost of the food I eat each month in my meal plan to see how much I am spending a day in food.
First, I choose BMW, model 3-series Then i choose Honda, in cells Model still 3-series (data validation match error) untill i choose model from the new list. How can i make that cell *model blank when i choose other *make (such as Honda in case)?
![Eminem - Fuel (Shady Edition) feat. Westside Boogie & GRIP [Official Audio]](http://i.ytimg.com/vi/k1OquBida9s/mqdefault.jpg)
You have a great style of teaching, clear and concise with just the right pace. Thanks for the content , very much appreciated.
This is helpful, but waaaay more complicated than what I'm looking for. I just need to assign a value to each item on my yes/no/somewhat drop down list. Maybe the previous video is a little simpler. Anyway, I'm glad you have videos like this for reference if ever I need more complicated sheets.
Please make one more video about how to do like that for multiple rows. Huhu.
its my question too
Is there a way to select multiple options on a dropdown list?
You save my life.
Thank you very much.
May God Bless you and your family.
Its very much helpful to me . Thanks
First of all: Thank you for this excellent Videos. They are fun to learn! One question: I have a 3-Level Dropdown, but not all Data Rows have 3 Entries. So if I choose a row with only 2 Columns, the Validtion for the 3rd Level disappears, but the value of the last selection remains in the cell. How to clear this?
How do I make the color change when I change the name
Thanks sir.
Very useful lesson.
Very Good and simple technic. Super.
I want to ask: Which method is more efficient if you had say a massive dataset: is it unique(query) or filter?
Would pe possible to also prevent duplicates in dropdown?
Thank you. If i'll change "make" . Can we make rest of the columns blank.
What if we have 2 different data set in different sheet, can we use the same technique?
Thanks for the great work!
I saw a video wherein it said i can also use the 'indirect' formula, can i also use that? Or this is more easier? this filter formula?
Sir please tell me how to implement it on other row
Thx for the session, but how to apply for the entire column in the depended sheet?
hello can you direct me to the right video I need if my data list is from column a - and they select an item from the list I want it to show column b c and d in relation to the item they selected - so if a had 15 items and they select the 12th item it will auto fill b,c,d column corresponding to the 12th line - btw thank you for all the help you have provided
Instead of making separate tabs of models and model versions, should be able to put formula into data validation as "Custom Formula is" section thus making it cleaner? Appreciate these tutorials...Thanks and I'm learning.
Tried doing that, didn't work. Custom formula only accepts true/false logical tests.
DARN, would had been nice. Thanks for the reply.
Is it possible that insert drop down list from the other spreadsheet? Or it has to be in the same spreadsheet?
Thanks for the video !
thank you i have one question is it possible change the color like yes Green and Nor Red
Yes. Watch my conditional formatting videos for that, I have tons of those.
or you can use QUERY to make the validation ranges only take two columns instead of two whole tabs.
"select Col2" and "select Col3"
Yes you can.
Is there a way to use multiple selection dropdown list? I have been searching the web for weeks and have not yet found a solid solution or script.
No good solution, just some wacky ways that are not exactly solutions.
Hi there how about for multiple rows do you have tutorial with that? Please reply ASAP
Make - Model - Verion
1. Honda - HondaM1 - HondaV1
2. BMW - BMWM1- BMWV1
3. Audi - AudiM1- AudiV1
etc. . . .
ruclips.net/video/s-I8Z4nTDak/видео.html
How can I select multiple choice on drop-down list?
No good way at the moment.
how to merge two ranges in single dropdown list in excel
Sorry this hasn't anything to do with this validation..how can I use upper correctly, and then just keep one column, and if people enter names or whatever the letters become all caps?? Please help with this..
Do you want to force them to enter everything in all caps or do you want to correct what they enter? In case you want to correct, do you want it to become all caps in the cell they type or in a different cell?
@@ExcelGoogleSheets I want when they enter lowercase it automatically turns into all caps, and stays in all caps. Can you help with this. By the way your content is amazing and very helpful.
You'll have to use a script for that. Something like this should work. Make sure you adjust sheet name & column number.
function
onEdit(e){
var range = e.range;
if(range.getColumn() === 2 && range.getSheet().getName() === "Sheet1"){
range.setValue(e.value.toUpperCase());
}
}
It only works on one row? That's way too much work for a single row. I need about 60 rows that work in that exact same way.
You'll have to use a script ruclips.net/video/s-I8Z4nTDak/видео.html
This only works for single rows unfortunately
Good video!
Unfortunately, here is no "Multiple Selection" in a single dropdown what I'm looking for right now. =(
Yea, that would be very difficult to accomplish, there is no stock functionality to handle anything like that. You need to use a script for that and even then the solution is not very pretty. Why do you feel you need this anyways?
@@ExcelGoogleSheets well, let's say you have the column A with country relation 1-to-1. In the same time you have country set 1-to-many in the column B.
I'm stack with column B, as you guess.
I'd love to have multi selection from a source of cells for B as for A.
I'd say use web app for data entry form if possible. You should be able to create that in a web app.
@@ExcelGoogleSheets thank you for your advice.
I'll investigate it.
how to convert yes no to ❌✅ ️checkbox/tick ?
ruclips.net/video/Nh5DbRMOlYU/видео.html
Do you have a video in which a user selects an item from a droplist. Say the item is called "bacon" it will add the $ value of said item to a column?
if this helps: I want to make a meal cost spreadsheet to calculate the cost of the food I eat each month in my meal plan to see how much I am spending a day in food.
Check out my VLOOKUP videos. www.chicagocomputerclasses.com/youtube-learn-google-spreadsheets/
Could you tell me, how this formula can be applied on the entire column?
🙏🏻
18min? no way im betting on this one
This only works for one row... no sustainable solution for multiple rows
I have a couple of script solutions for multiple rows on the channel.
First, I choose BMW, model 3-series
Then i choose Honda, in cells Model still 3-series (data validation match error) untill i choose model from the new list.
How can i make that cell *model blank when i choose other *make (such as Honda in case)?