This is awesome and the simplest version I've seen. Is there a way to make the list a bulleted list in the cell vs being separated by commas? Thank you so much!
I love the explaination. It is simple and clear. Can we remove a value from the list? Lets say we want to relove wolf and change it for dog for ie. I was thinking of using this to highlight project dependencies in sheets. The dropdown would have the task names and the selected values would be the task dependencies for a given task. Ie : Task = order pizza with cynthia Dependencies : call the pizza place, wait for cynthia to arrive The goal would be to be able to adjust start date and end date based on the dependencies.
Very nice way to implement this into a practical situation! Try this: if(activeCol==2 && activeRow>2 && activeSheet.getName()=="Table"){ var newList=listValue+","+activeValue if(listValue=="") listCell.setValue(activeValue) else if(checkForDuplicates==-1) listCell.setValue(newList) else if(checkForDuplicates!=-1) listCell.toString().replace(listValue) } Regards!
Hi, this works fine, but how do I make the offset values for specific range like if I select drop down from "E" range to only put it in "F" range and not the other ranges😢
Hey, your video was awesome and very clear! It is a shame that GSheets does not have this basic implementation yet. One sugestion is to make all the elements on the output list in the same order e.g.: alphabetically. Because if in the 1st row you select Cat, Dog, Wolf the output will be different if you select Wolf, Cat, Dog in the 2nd row.
You are right I have a more updated version of this video, and am doing some advanced variations. The alphabetical order one makes a lot of sense, and I will include it in part 3. Thanks for the suggestion! Here is the series th-cam.com/video/0FLPpHyiMkA/w-d-xo.html Kind Regards
Hi, this was so helpful. Thank you so much for sharing your knowledge. How can I apply the same script, but using a range of different values and in different columns and cells on the same sheet? I am new to this and your content has been very helpful!!
Hello, I am up to the section where you offset activeCell into the column next to it. What code can I use to make the selections appear in column in another tab of my document instead?
Thank you for this code! Is it possible to add different value based on the selected answer from the dropdown menu? What I am looking for: Let's say that in Options spreadsheet, I will have another column, Latin names of the animals, so if A2 is Dog, then B2 is Canis Familiaris. So when I choose Dog from dropdown menu in Table sheet, can I add value from B2, Option sheet (so Canis Familiaris) to C3 Table sheet, instead of the word Dog? In other words, if I choose Dog, can the words Canis Familiaris appear in the next column?
Is there a way to apply this to multiple tabs with identical format? Row and column are the same but I need to apply multiple selection function to all tabs.
I liked it. But is there any option if I can remove selected item when I select again from drop down list instead of removing it manually from selected column?
Just to keep this up to date, the UI has changed a bit, but this still works. When you select your data validation method, just make sure to select the Critera: "Dropdown (from a range)"
@@practicalsheets Nice one thanks .i have another requirement like need to create one more multiple dropdown parallel in next cell of the value in D dropdown &the value is in E,drop for let' say fruit.. how to create that can u help me
Hi at 10:36 you say, if you are happy for duplicates to happen, then that is it. Yes, i want duplicates, but it only happens if i choose dog,cat,dog. It does not work if i choose, dog, dog. How can i fix this?
Thanks for this video! I implemented the same solution but when I select a value from the drop down it takes 8-10s to show up in the selected values cell. How can I make it faster?
Nice one thanks .i have another requirement like need to create one more multiple in next cell of the value in D dropdown &the value is in E,drop for let' say fruit.hiw to create that
How can I tweak that to append the new selection in place? I think it works but the text concatenation appears underneath the dropdown menu, so it is not visible unless I remove the menu from the cell :/
@@practicalsheets function multipleSelection(){ var activeCell=SpreadsheetApp.getActiveRange(); var activeCol=activeCell.getColumn() var activerow=activeCell.getRow() var activeSheet=activeCell.getSheet() var activeValue=activeCell.getValue() var listCell=activeCell.offset(0,1) var listValue=listCell.getValue() if(activeCol==11 && activerow>2 && activeSheet.getName()=="A"){ var newList=listValue+","+activeValue if(listValue=="")listCell.setValue(activeValue) else listCell.setValue(newList) } } function onEdit(){ multipleSelection() }
Hello! For the moment, my system is to give the templates and code for the members of the patreon. I understand some people give their scripts in the description, but for now this is the way I have better found for this marvelous community to support the continuation of this content I hope you understand Regards!
This is the simplest I've seen someone explain a coding concept. This is just great.
This is awesome and the simplest version I've seen. Is there a way to make the list a bulleted list in the cell vs being separated by commas? Thank you so much!
Thank you!
I think so
Try this
if(activeCol==2 && activeRow>2 && activeSheet.getName()=="Table"){
var newList=listValue+"
•"+activeValue
if(listValue=="") listCell.setValue("•"+activeValue)
else if(checkForDuplicates==-1) listCell.setValue(newList)
}
Kind Regards
I love the explaination. It is simple and clear.
Can we remove a value from the list? Lets say we want to relove wolf and change it for dog for ie.
I was thinking of using this to highlight project dependencies in sheets.
The dropdown would have the task names and the selected values would be the task dependencies for a given task.
Ie :
Task = order pizza with cynthia
Dependencies : call the pizza place, wait for cynthia to arrive
The goal would be to be able to adjust start date and end date based on the dependencies.
Very nice way to implement this into a practical situation!
Try this:
if(activeCol==2 && activeRow>2 && activeSheet.getName()=="Table"){
var newList=listValue+","+activeValue
if(listValue=="") listCell.setValue(activeValue)
else if(checkForDuplicates==-1) listCell.setValue(newList)
else if(checkForDuplicates!=-1) listCell.toString().replace(listValue)
}
Regards!
Hi, this works fine, but how do I make the offset values for specific range like if I select drop down from "E" range to only put it in "F" range and not the other ranges😢
Hey, your video was awesome and very clear!
It is a shame that GSheets does not have this basic implementation yet.
One sugestion is to make all the elements on the output list in the same order e.g.: alphabetically.
Because if in the 1st row you select Cat, Dog, Wolf the output will be different if you select Wolf, Cat, Dog in the 2nd row.
You are right
I have a more updated version of this video, and am doing some advanced variations. The alphabetical order one makes a lot of sense, and I will include it in part 3. Thanks for the suggestion!
Here is the series
th-cam.com/video/0FLPpHyiMkA/w-d-xo.html
Kind Regards
Thank you for this straight-forward and easy to understand google sheet coding solution.
Hello Juan, Did any of this change with the 2023 update to sheets?
Hello!
It shouldn´t have changed
Kind Regard!
Genius and new idea.
Although I hate programming, you made it clear and simple.
Thanks a lot
Thx for the kind words!
Hi, this was so helpful. Thank you so much for sharing your knowledge.
How can I apply the same script, but using a range of different values and in different columns and cells on the same sheet?
I am new to this and your content has been very helpful!!
Hello, I am up to the section where you offset activeCell into the column next to it. What code can I use to make the selections appear in column in another tab of my document instead?
Thank you for this code! Is it possible to add different value based on the selected answer from the dropdown menu?
What I am looking for:
Let's say that in Options spreadsheet, I will have another column, Latin names of the animals, so if A2 is Dog, then B2 is Canis Familiaris. So when I choose Dog from dropdown menu in Table sheet, can I add value from B2, Option sheet (so Canis Familiaris) to C3 Table sheet, instead of the word Dog?
In other words, if I choose Dog, can the words Canis Familiaris appear in the next column?
Hello!
You could do this with a VLOOKUP formula in C3
VLOOKUP(B3;Options!A:B;2;0)
Regards!
Is there a way to apply this to multiple tabs with identical format? Row and column are the same but I need to apply multiple selection function to all tabs.
I liked it. But is there any option if I can remove selected item when I select again from drop down list instead of removing it manually from selected column?
Great! but do we have to pay just to get your formula?
Hello
I can give you the formula practicalsheets@gmail.com
Some people like to support me
Regards!
Just to keep this up to date, the UI has changed a bit, but this still works. When you select your data validation method, just make sure to select the Critera: "Dropdown (from a range)"
Thanks for sharing!
Here is a more updated version
th-cam.com/video/0FLPpHyiMkA/w-d-xo.html
Kind Regards
Thank you for this! How can I copy onto multiple tabs on same worksheet?
This worked PERFECTLY for what I was needing! Thank you so much!
Great news!
@@practicalsheets Nice one thanks .i have another requirement like need to create one more multiple dropdown parallel in next cell of the value in D dropdown &the value is in E,drop for let' say fruit.. how to create that can u help me
Hi at 10:36 you say, if you are happy for duplicates to happen, then that is it. Yes, i want duplicates, but it only happens if i choose dog,cat,dog. It does not work if i choose, dog, dog. How can i fix this?
Thanks for this video! I implemented the same solution but when I select a value from the drop down it takes 8-10s to show up in the selected values cell. How can I make it faster?
I am getting the error "TypeError: ListValue.toString(...).IndexOf is not a function"
Any suggestions?
May you send me your code?
Kind Regards
You made it so simpler and clear, thanks, it worked like a gem
Thanks so much, this was incredibly useful!
Thank you for commenting!
Any suggestions on what to do if I am getting a red error code saying the code is invalid? Thanks
Sometimes you may be missing a comma, a parenthesis or a bracket
Kind Regards
thank you very well explain exactly what I needed!
Thank you for commenting!
Nice one thanks .i have another requirement like need to create one more multiple in next cell of the value in D dropdown &the value is in E,drop for let' say fruit.hiw to create that
How can I tweak that to append the new selection in place? I think it works but the text concatenation appears underneath the dropdown menu, so it is not visible unless I remove the menu from the cell :/
Hello!
I´m not sure I understand the particular case
Regards!
can I do this and apply to the entire column on a single sheet? and on multiple cells in a single sheet?
It should work!
Let me know if it doesn´t
Regards!
Thank you so much for the detail! It is awesome and so helpful!👍
Thanks!
I tried it and it works but when I tried it for another column in the same sheet, it blocks each other, if one works, the other stops. Any solutions?
Let me see your code
Regards!
@@practicalsheets
function multipleSelection(){
var activeCell=SpreadsheetApp.getActiveRange();
var activeCol=activeCell.getColumn()
var activerow=activeCell.getRow()
var activeSheet=activeCell.getSheet()
var activeValue=activeCell.getValue()
var listCell=activeCell.offset(0,1)
var listValue=listCell.getValue()
if(activeCol==11 && activerow>2 && activeSheet.getName()=="A"){
var newList=listValue+","+activeValue
if(listValue=="")listCell.setValue(activeValue)
else listCell.setValue(newList)
}
}
function onEdit(){
multipleSelection()
}
@@practicalsheets
I tried it now again but unfortunately it doesn’t work for any column
@@marwaomar9127 HEllo! I would have to see the code. Regards!
Work perfectly
Thank you so much
Thank you!
Hello sir.when i run this script this error comes for me."spreadsheetapp is not defined".what should i do for it?
Hello
Be careful with capitalization
SpreadsheetApp
Regards!
how would you delete if incase you erroneously selected one or two?
ReferenceError: activeCol is not defined i am getting this error
At first I'm like this is the wrong video, then I saw column C and I was like aaaaahhhh, ooooooo.
I assume then, that it was useful (althought a bit deceptive, haha). Hope it worked
Regards!
I tried with your code but it dint worked can u suggest what might have been problem.
Hello!
Can you show me the code you have?
Regards!
can anyone help it is not working and I dont know why. Its like its not even being added to my sheet. iv copied it exactly
Were you able to solve?
Kind Regards
@@practicalsheets no
yes its not working though
@@vjarun_og_yt Could you share your code? Kind Regards
How can i clear the cells in this code?
Hello! I will work on a second version with your comments.
Regards!
@@practicalsheetswhere you able to do a second version?
I am interested in this result.
@@sarahnarcisse1275 Yes. Here it is
th-cam.com/video/0FLPpHyiMkA/w-d-xo.html
Kind Regards
Thank you!
Please include the final code in the video description so I can copy it and just make the modifications as needed. thank you.
Hello!
For the moment, my system is to give the templates and code for the members of the patreon.
I understand some people give their scripts in the description, but for now this is the way I have better found for this marvelous community to support the continuation of this content
I hope you understand
Regards!
Amazing man ! Thanks
Thx so much!
wow amazing
Thanks a lot 🤩😍
Thank you for commenting!
This should be a built in feature.
Agree
Now I want to create formula that will multiply the number of selected items by another cell.
Interesting!
We could count them using SPLIT
=COUNTA(SPLIT(B2,","))*C2
Hope it helps
Regards,
its not working only
Hi!
Any specific error?
Kind Regards
This vdo only for genuis engineer
Hello!
Sorry it is a bit complicated
I try to make it easy to follow but I know sometimes I fail
Thanks for commenting
Regards!