#Excellent #Excellent #Excellent _You Are My Best Teacher From 5 Year at UA-cam For Google Sheet etc._ there was my first phone which sam j7 nxt had display damged.
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
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?
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
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.
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!
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
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.
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, 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.
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. 😄
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 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.
#Excellent #Excellent #Excellent _You Are My Best Teacher From 5 Year at UA-cam For Google Sheet etc._ there was my first phone which sam j7 nxt had display damged.
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.
#Excellent #Excellent #Excellent
_You Are My Best Teacher From 5 Year at UA-cam For Google Sheet etc._
there was my first phone which sam j7 nxt had display damged.
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
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?
can we make dropdown list that doesn't repeat selected items in google sheets?
Is there a way to get of the drop down box border?
When I used the colored chips dropdown, my query stopped reading the data from that column. Any solution to this?
What query?
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
👍
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.
same thoughts
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!
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
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.
A cool feature with the Chip display style is that it turns the selections into People Chips if your criteria input are email addresses 🎶🎷
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.
Watch FILTER or QUERY function videos.
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.
Formulas in validation still don't work, so well have to just stick to scripts like we used to for this sort of thing.
You're always the best teacher of me :) Thanks
Thank you! 😃
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. 😄
Great to hear!
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?
Is it possible you had to just refresh the page?
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.
Where is the formula located? Which cell?
@@ExcelGoogleSheets B2
try
=COUNTIFS(Stephanie!Date,(COLUMN()-1)&"Jan")
@@aliabbasi5536 Assuming your old formula worked in column B, then it should work in the same place.
Thanks! But how to remove the pencil icon at the bottom of the dropdown list?
I don't think you can remove it.
Only people who can edit the page will be able to see the pencil I believe
#Excellent #Excellent #Excellent
_You Are My Best Teacher From 5 Year at UA-cam For Google Sheet etc._
there was my first phone which sam j7 nxt had display damged.
*Sir*_Your Last Words is Awesome in All Videos_
"i will see u in next one"
Cool. 👍🏻
Google Sheets gets better and better.
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.
The solution is Filtered Views.
@@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.
@@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.