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
Жыл бұрын
👍
@nurserytoys
Жыл бұрын
#Excellent #Excellent #Excellent _You Are My Best Teacher From 5 Year at KZitem For Google Sheet etc._ there was my first phone which sam j7 nxt had display damged.
@systembucket
Жыл бұрын
You're always the best teacher of me :) Thanks
@ExcelGoogleSheets
Жыл бұрын
Thank you! 😃
@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
@AnimaJobs-v5n
Жыл бұрын
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?
@nabinshrestha8495
Жыл бұрын
can we make dropdown list that doesn't repeat selected items in google sheets?
@phan5302
Жыл бұрын
Is there a way to get of the drop down box border?
@bassam4073
Жыл бұрын
When I used the colored chips dropdown, my query stopped reading the data from that column. Any solution to this?
@ExcelGoogleSheets
Жыл бұрын
What query?
Жыл бұрын
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
@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!
@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
@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.
@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 🎶🎷
@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.
@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!
@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.
@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?
@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.
@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 KZitem 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"
@66Komodo
Жыл бұрын
Cool. 👍🏻 Google Sheets gets better and better.
@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.
Пікірлер: 41