Finally multiple choices on dropdown menu! That will allow a bunch range of applications now. I've been waiting for this for years! Thanks for sharing, love your channel!
This is a nice addition to the functionality of dropdown lists. But in my needs, I have for instance a vendor dropdown list of over 50 selections which then has a category list of multiple items that is specific to each vendor and then a sub-category list specific to each vendor and category list. Yes, it is intense and I made it work my way which I do not like. Hopefully, Google will come up with a functionality that make this operation easier. Thanks for your videos, I've learned a lot from you!
👍🏻 That is indeed nice! Unfortunately not available in the app version of Google Sheets, which only goes as far as adding data validation for individual dropdown items. No colour, no multiple choice. Hopefully soon .. or at least hopefully Google will soon allow users with the app installed to _choose_ to use the browser version for full access to all the forbidden features
Great review of this feature, thanks. Question though - do you have or know of a good starting point to learn Regex from knowing little or nothing about it? I've looked and everything I seem to locate kind of dives into it absent of a good lead in. Which is fine for those versed enough to pick it up but not so much for the totally green beginner.
Looking forward to Dynamic Drop down. Google Sheet doesn't support before like excel. If you have any idea/update about please let us know and make a video about the same.
Hi I once saw a video of someone clicking on a cell and it expanded or pop upped additional information in a cell form. Do you have any videos on this? I've been searching and all I'm getting is pop up alerts or messages or pop charts and calendars. If you can help would be appreciated
I haven't tested it, but it's pretty safe to assume that regex is always the worst option. You typically see that when you start using regex expressions on large datasets on any system. My rule of thumb "don't use regex unless you have to". That being said, split doesn't work the same as word boundaries. for example "apple,pear" or "apple.pear" is a word boundary, but splitting by space won't help in both cases.
@@ExcelGoogleSheets yeah, I have the same feeling about regex, they are very powerful but at a cost. I mentioned split thinking on the multiple selections. Thanks!
In a scenario where some values contain a comma themselves, how to split the values in order to x/vlookup those values based on another criteria. Unless there's an option to change the *delimiter* between the multiple selection validation, which I failed to find.
Finally multiple choices on dropdown menu! That will allow a bunch range of applications now. I've been waiting for this for years! Thanks for sharing, love your channel!
Thanks!
Appreciate it!
1:37 multiple selections is awesome! I can't believe I missed that!😮 Thanks!❤🎉
This is a nice addition to the functionality of dropdown lists. But in my needs, I have for instance a vendor dropdown list of over 50 selections which then has a category list of multiple items that is specific to each vendor and then a sub-category list specific to each vendor and category list. Yes, it is intense and I made it work my way which I do not like. Hopefully, Google will come up with a functionality that make this operation easier. Thanks for your videos, I've learned a lot from you!
I tried it on my spreadsheet, it works great!
Thanks for sharing. Learned something new today!!
👍🏻 That is indeed nice!
Unfortunately not available in the app version of Google Sheets, which only goes as far as adding data validation for individual dropdown items. No colour, no multiple choice. Hopefully soon .. or at least hopefully Google will soon allow users with the app installed to _choose_ to use the browser version for full access to all the forbidden features
Great review of this feature, thanks. Question though - do you have or know of a good starting point to learn Regex from knowing little or nothing about it? I've looked and everything I seem to locate kind of dives into it absent of a good lead in. Which is fine for those versed enough to pick it up but not so much for the totally green beginner.
Ele tem uma série de vídeos. Aqui nessa playlist você pode aprender:
ua-cam.com/play/PLv9Pf9aNgemsZFkXpxeODgAD4eB2gUW5y.html&si=VUZaS8OZvUifKVFZ
Thanks @DidoBohrer
Can we point to a cell in the regular expression instead of typing the word? Like at point 14:13....
👍🏻
Looking forward to Dynamic Drop down.
Google Sheet doesn't support before like excel.
If you have any idea/update about please let us know and make a video about the same.
Hi I once saw a video of someone clicking on a cell and it expanded or pop upped additional information in a cell form. Do you have any videos on this? I've been searching and all I'm getting is pop up alerts or messages or pop charts and calendars. If you can help would be appreciated
Hi! Sir, can you make a tutorial for the dropdown list that selects multiple selections and it can filter the data in the pivot table.
Not bad example
is this possible in ms excel?
Is there a way that I can use this and incorporate adding up dollar amounts.
Sure, use SUMIFS instead.
Do you know it have tested performance between using regex vs something like split?
I haven't tested it, but it's pretty safe to assume that regex is always the worst option. You typically see that when you start using regex expressions on large datasets on any system. My rule of thumb "don't use regex unless you have to".
That being said, split doesn't work the same as word boundaries. for example "apple,pear" or "apple.pear" is a word boundary, but splitting by space won't help in both cases.
@@ExcelGoogleSheets yeah, I have the same feeling about regex, they are very powerful but at a cost. I mentioned split thinking on the multiple selections. Thanks!
In a scenario where some values contain a comma themselves, how to split the values in order to x/vlookup those values based on another criteria.
Unless there's an option to change the *delimiter* between the multiple selection validation, which I failed to find.
Being able to choose which separator to use would be a great update for a future version.
Good question, I don't think there is one.However, the value with commas will be in quotes: "Chocolate, Vanilla", Coffee