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.
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?
How do I make the color change when I change the name
4 года назад+1
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?
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. . . .
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.
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()); } }
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)?
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.
You save my life.
Thank you very much.
May God Bless you and your family.
Please make one more video about how to do like that for multiple rows. Huhu.
its my question too
Its very much helpful to me . Thanks
Is there a way to select multiple options on a dropdown list?
Thanks sir.
Very useful lesson.
Very Good and simple technic. Super.
Thanks for the great work!
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?
How do I make the color change when I change the name
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?
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?
I want to ask: Which method is more efficient if you had say a massive dataset: is it unique(query) or filter?
Sir please tell me how to implement it on other row
Would pe possible to also prevent duplicates in dropdown?
Thanks for the video !
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
Is it possible that insert drop down list from the other spreadsheet? Or it has to be in the same spreadsheet?
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.
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.
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 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 to merge two ranges in single dropdown list in excel
18min? no way im betting on this one
🙏🏻
How can I select multiple choice on drop-down list?
No good way at the moment.
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.
This only works for single rows unfortunately
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
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/
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)?
Could you tell me, how this formula can be applied on the entire column?