#Excellent #Excellent #Excellent _You Are My Best Teacher From 5 Year at KZfaq For Google Sheet etc._ there was my first phone which sam j7 nxt had display damged.
@andyyromano Жыл бұрын
Hey i wanted to say thanks to you because of all the videos that you have done. They are super helpful. You explain in a very calm and detailed way so no details are left to understand. Currently im working in an spreadsheet using both scripts and various formulas I have never knew they existed and you are part of the progress. Take care! :D
@ExcelGoogleSheets Жыл бұрын
👍
@johnmillersr.colorado Жыл бұрын
Helpful tutorial as well as comments/observations by subscribers. Thanks so much. I tend not to go exploring for new features so subscribing to this channel really helps keep me informed. 😄
@ExcelGoogleSheets Жыл бұрын
Great to hear!
@hylpemadras Жыл бұрын
A cool feature with the Chip display style is that it turns the selections into People Chips if your criteria input are email addresses 🎶🎷
@justbelit Жыл бұрын
happy to see features similar to notion. what about multi-selection per cell for example selecting different items (chip colours) per cell. For e.g tomato, cheese, mustard all in one cell as different chip colours
@systembucket Жыл бұрын
You're always the best teacher of me :) Thanks
@ExcelGoogleSheets Жыл бұрын
Thank you! 😃
@helmanfrow Жыл бұрын
This sidebar completely replaces the old data validation modal dialog. It has all the same features with the addition of color options, which is new. Fun fact: The range field for _List (from a range)_ still does not autocomplete when you start typing a named range. 🙄 Let's hope they finally get that right. Also I found and reported a bug where resetting the color of a list item gives the cell a grey background instead of white.
@lionsground Жыл бұрын
Hello I have a question about your video "IMPORTJSON Function - Google Sheets Tutorial". Is it possible to keep the pre-existing data in the spreadsheet instead of refreshing the entire sheet with new data? I am running a radio and I want to have a complete play history. So a new entry needs to be added to the sheet? Thanks! 🙏🙏
@Sparks2313 Жыл бұрын
Hello, thank you for this video! Is there a way to copy the colors of a list from one sheet to the next without using conditional validation? For example, if you use red for Shipped, blue for Packed and green for Cancelled, do I need to manually set the colors every time? I have a dropdown with over 15 options and I don't want to have to select them manually every time I start a new sheet but use the same words and colors as other sheets. I did conditional formatting but I want the text to appear in the "chip" format. Thanks!
@user-vy1bz6hw4b Жыл бұрын
I have question: Q1: If I filter the data using the filter button at column C 'Sales Rep', filtering to 'Nia' , how to calculate for sum for column E 'Status'? as its in 'TEXT' form Q2: Assuming the entire column E 'Status' have been updated with choosen options from the dropdown list, how to calculate for sum of visible cells if I were to filter this column to show only 'Shipped' option?
@phan5302 Жыл бұрын
Is there a way to get of the drop down box border?
@nabinshrestha8495 Жыл бұрын
can we make dropdown list that doesn't repeat selected items in google sheets?
@66Komodo Жыл бұрын
Cool. 👍🏻 Google Sheets gets better and better.
@garychadwick1240 Жыл бұрын
Another great explanation thanks. As it happens I was using this a few days ago. I had a dropdown pointing to a range of 2 cells. In one cell was a formula to calculate the previous stockmarket trading date. In the second cell it was just a manually set date. I found that if I selected the dropdown date set by the formula cell, when I loaded the sheet the next day, although the date had changed in the formula cell, the date in the drop down cell had not updated the date from the formula cell and didn't do so until I re-selected it from the dropdown again. Is there a way around this?
@ExcelGoogleSheets Жыл бұрын
Is it possible you had to just refresh the page?
@beeldbuijs1003 Жыл бұрын
Hi, I use dependable drop down lists with the chips option. I fill them with a range, depening on the menu that is chosen in the previous column. I'd like to also color the chips or hide them, depending on the menu item, chosen in the previous column. Is this possible? I mean with a function, instead of manually. Thank you.
@ExcelGoogleSheets Жыл бұрын
Formulas in validation still don't work, so well have to just stick to scripts like we used to for this sort of thing.
@bassam4073 Жыл бұрын
When I used the colored chips dropdown, my query stopped reading the data from that column. Any solution to this?
@ExcelGoogleSheets Жыл бұрын
What query?
@pavelkostyluk1362 Жыл бұрын
Thanks! But how to remove the pencil icon at the bottom of the dropdown list?
@ExcelGoogleSheets Жыл бұрын
I don't think you can remove it.
@Unleashed75 Жыл бұрын
Only people who can edit the page will be able to see the pencil I believe
@nurserytoys Жыл бұрын
#Excellent #Excellent #Excellent _You Are My Best Teacher From 5 Year at KZfaq For Google Sheet etc._ there was my first phone which sam j7 nxt had display damged.
@nurserytoys Жыл бұрын
*Sir*_Your Last Words is Awesome in All Videos_ "i will see u in next one"
@shivbhagat4098 Жыл бұрын
Hi =QUERY(👉{'17-18'!B4:DW}, 👈howcan i add a dropdown list reference here from below list "Select Col12, Col7 Where Col7 is not null ORDER BY Col12 ASC",0) 2017-18 17-18'!B4:DW 2018-19 18-19'!B4:DW 2019-20 19-20'!B4:DW 2020-21 20-21'!B4:DW 2021-22 21-22'!B4:DW 2022-23 22-23'!B4:DW 2023-24 23-24'!B4:DW
Жыл бұрын
We didn t like new dv editing. İts give big pain if you have hundreds of dv in same sheet. Because it lists all dv rules without any sort. Not practicall.
@angellynpascual9828 Жыл бұрын
same thoughts
@you3d Жыл бұрын
The problem with Google Sheets is that you can only use a function, e.g. a Query function, one at a time, else you'll ruin the query search of other users viewing the sheet.
@ExcelGoogleSheets Жыл бұрын
The solution is Filtered Views.
@you3d Жыл бұрын
@@ExcelGoogleSheets Yes, sadly, without the customizations as seen in the use of data entry forms that can only be used by one person/user at a time.
@ExcelGoogleSheets Жыл бұрын
@@you3d HTML forms in sidebars and modals can be used by more than one user at the same time, but they are much more difficult to build.
@abbasiali Жыл бұрын
Hi There, Appreciate a very well-explained video. I struggled with the chip option when it was introduced without prior information. I have a question for you. I am looking to create a google sheet that data will be imported from another sheet. My challenge is I have to pull data for one person multiple times. VLOOKUP only pulls data one time. Please let me know or share the video link if a tutorial exists.
@ExcelGoogleSheets Жыл бұрын
Watch FILTER or QUERY function videos.
@abbasiali Жыл бұрын
Hi There, I have a couple of questions, and I would appreciate your reply. =COUNTIFS(Stephanie!Date,"1Jan") I want to drag this cell to the extreme right cell to get the 31Jan. My challenge is to get the dates in sequence, but it still needs to happen. I would really appreciate any suggestion/alternative you have about this.
@ExcelGoogleSheets Жыл бұрын
Where is the formula located? Which cell?
@abbasiali Жыл бұрын
@@ExcelGoogleSheets B2
@ExcelGoogleSheets Жыл бұрын
try =COUNTIFS(Stephanie!Date,(COLUMN()-1)&"Jan")
@ExcelGoogleSheets Жыл бұрын
@@aliabbasi5536 Assuming your old formula worked in column B, then it should work in the same place.