#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.

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

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. 😄

A cool feature with the Chip display style is that it turns the selections into People Chips if your criteria input are email addresses 🎶🎷

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

You're always the best teacher of me :) Thanks

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.

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! 🙏🙏

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!

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?

Is there a way to get of the drop down box border?

can we make dropdown list that doesn't repeat selected items in google sheets?

Cool. 👍🏻 Google Sheets gets better and better.

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?

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.

When I used the colored chips dropdown, my query stopped reading the data from that column. Any solution to this?

Thanks! But how to remove the pencil icon at the bottom of the dropdown list?

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.

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.

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.

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.