Google Sheets now has native multi-select dropdowns. support.google.com/docs/thread/287944726/google-sheets-allow-dropdown-chips-to-have-multiple-selections?hl=en
@jeremykahan89474 жыл бұрын
I just had a different idea. You could put multiple single selections at the far right, and then =JOIN() them into the column with the complete list. I will grant that it's a bit annoying, but it's all within functionality of sheets (and no script).
@celestinapolicina74823 жыл бұрын
Thanks for the idea! I'm actually looking a way within Google Sheets and no script. I'm trying to make the sheet as friendly as possible for other people who don't need to look into other parts like scripts.
@captiveCorsair4 жыл бұрын
Your voice is really soothing. Thanks for the ideas. I wish Google Sheets would implement a checkbox dropdown list, like Excel has
@ProlificOaktree4 жыл бұрын
Thanks for the compliment. Yeah, the drop down's in Sheets are a bit limiting.
@erikagriffin2899 Жыл бұрын
I've been looking for something similar to Notion - thank you for the information and tutorial!
@ProlificOaktree Жыл бұрын
Glad it was helpful!
@Vejcucnikos5 ай бұрын
Hey, I would like to know, if it would be possible to add into the script, that it would copy Formatting for the individual checkboxes from the column it is copying from. I'm horrible when it comes to any kind of programming, and I would apreciate some help with this. Either way.. great video!
@sunnychen9756Ай бұрын
I believe google has implemented this function in to google Sheets now so you don't have to worry about any methods he mentioned anymore. It is a built-in function now.
@VejcucnikosАй бұрын
@@sunnychen9756 Oh, really? That's cool then. Thanks for the info!
@AnyFactor3 жыл бұрын
I was about to write how this is is so convenient in notion
@denh5553 жыл бұрын
just what i needed - thank you Option 1 is great
@ProlificOaktree3 жыл бұрын
Awesome, glad it helped.
@eliselevi5643 жыл бұрын
Is there a way to add several different multi-select dropdowns within the same spreadsheet?
@JeremieBPCreation2 жыл бұрын
Good video but I think the like / dislike ratio is not great (7.9 : 1) because the title is misleading. As it is written "Google Sheets | Three Alternatives for Multi-Select Dropdowns" sounds like three solutions that work from within Sheets. Also, it takes a while before we find out it's not the case which can feel like we were intentionally tricked. Plus, to someone looking quickly who doesn't the service, the bit ly link can look like an undisclosed sponsor link. I understand if you want to keep the "Google Sheets |" part for cohesion with other video titles in a series, but maybe I'd change the rest for something like: "Multi-Select Dropdowns: Sheets Solution + Two Alternatives" To reduce chances of feelings of time waste even further, I'd rename the "Mystery solution" part to something like "Third Solution: notion . so" Anyway, just my thoughts on the matter. Have a nice day! :)
@ProlificOaktree2 жыл бұрын
Thanks for the feedback. I appreciate you taking the time to let me know your thoughts. I see the video as showing alternatives to Google Sheets multi-select drop downs. The viewer then finds out what they are. Using another program is a valid alternative to this issue that occurs in Sheets. For what it's worth though, I think your title is a good one too.
@gokum79554 жыл бұрын
Thank you so much for teaching this information to us......great channel.!!!
@ProlificOaktree4 жыл бұрын
Ha, thanks!
@chabotpal2643 жыл бұрын
These videos are incredible resources. Thank you!!
@mwise79603 жыл бұрын
Option 2...Life saver! Thanks Sir.
@brunovincent55732 жыл бұрын
My sheet has no "Insert Form" maybe that feature is gone now?
@ProlificOaktree2 жыл бұрын
It moved to Tools.
@jennifercantu65294 жыл бұрын
I don't see the link for the script. Is it still available?
@ProlificOaktree4 жыл бұрын
It's linked to the spreadsheet at the bit.ly link in the description.
@rodrigomgaio3 жыл бұрын
Fantastic video! Thanks a lot, mate.
@ProlificOaktree3 жыл бұрын
You’re welcome! Glad you liked it.
@myfaithstory1 Жыл бұрын
I don't have the option to insert a form under my INSERT dropdown in Sheets. Has this option been removed, or do I need to somehow update my version of Google Sheets?
@ProlificOaktree Жыл бұрын
You wouldn't need to update the version, Google controls that. My best guess is that you don't have enough permissions for the sheet. If you are the owner of the Sheet, you should be able to do it.
@sandraewell26413 жыл бұрын
I was able to open a copy of the multiple selection sidebar workbook. Is it possible to add the custom dropdown to a column in another google sheet? Or should I build my sheet around this one? Thank you.
@chaddeal93264 жыл бұрын
Thanks for this great info. I used the script option and it works great. Is there an easy way to apply that script to other existing sheets?
@ProlificOaktree4 жыл бұрын
No, it only works on one at a time.
@jordan796742 жыл бұрын
can i take a cell with multiple inputs and give them a value to be calculated in another cell, eg. the sun and the record newspaper one is 0.70 and the other is 0.95 together would be 1.65 but then advance this for a full week?
@michaelsintes54872 жыл бұрын
Hello Sir. Thanks for the video. If the cell already contains one or more entries, would it be possible that the checkboxes are already checked when the sidebar loads?
@roozbehebadi66612 жыл бұрын
Really Appreciate It!
@ProlificOaktree2 жыл бұрын
Thanks, I'm glad it helped.
@gamingstew7033 жыл бұрын
I followed all of the script instructions but when I opened the sidebar, all I saw was "fill active cell" and "rebuild options" buttons, neither of which did anything :(
@gamingstew7033 жыл бұрын
I saw that it worked in the copy and realized that it just isn't seeing the values associated with the dropdown, maybe its a think on my end...
@Jotaz Жыл бұрын
@@gamingstew703 I had the exact same issue and after some trial and error I found out that it is because I was logged into multiple google accounts at the same time. Apparently this is an old and known bug regarding apps script and the only way to fix it is to log out of the other acocunts...
@marketingofficer65893 жыл бұрын
Hi super informative, is it possible to make each choices transposed vertically (the 2nd choice will be entered on the 2nd row, below the 1st choice) I am going to use it for a guest with multiple room bookings, bec. each rooms are with different prices. I'm also open for adding script if necessary. Thank you
@ProlificOaktree3 жыл бұрын
Not that I can think of.
@mercedescavani4 жыл бұрын
Hi, I clicked the Apps Script link, but it goes to a Docs Editor Help page
@ProlificOaktree4 жыл бұрын
I got confused when looking at it too. That is the right link but I added to the explanation that it's a third of the way down the page. I wanted to give the person that posted it some credit.
@mercedescavani4 жыл бұрын
@@ProlificOaktree Oh, I got it now! Thank you
@janethaas22853 жыл бұрын
If you create a form with multiple selection options, what's the best way to concatenate for analysis?
@ProlificOaktree3 жыл бұрын
In a column to the right, do =B2&", "&C2", "D2" etc.
@janethaas22853 жыл бұрын
@@ProlificOaktree what if I want to know the # responses to each checkbox separately ( such as barriers to care: shortage of supplies, shortage of staff, acuity of patients or none) I want to add them up by each barrier separately and am having trouble with that.
@ProlificOaktree3 жыл бұрын
@@janethaas2285 =countif(A1=TRUE) would count a checkbox if it's checked.
@delinquense3 жыл бұрын
Yeah, great. And if you permit users to be able to change their form (which you would want to do quite often) after they submit it, checkboxes won't work. They won't be able to undo previous choices, but will be able to add new ones. So, you guessed it ... practically useless.
@92MrAlvin2 жыл бұрын
Hi Sir. Thank you for the video. Is that possible for Google sheet to have a multiple tag option from a given data validation? The expected outcome will be at your video in 09:35 ...like option Mustard ; Mayo in Topping. I will appreciate for your help. Thanks.
@ProlificOaktree2 жыл бұрын
No, that's why this video is showing alternative ways to do this.
@92MrAlvin2 жыл бұрын
@@ProlificOaktree ok thank you Sir
@rickvidaurre78633 жыл бұрын
Thank you, but I think I'' stick with Excel
@eddyjreyes3 жыл бұрын
Is this the right link to copy: docs.google.com/spreadsheets/d/1cam1LNJgvWVDx_gmEVmPzuTYalTmsQWhZ7tlcHwAmCY/copy