Видео

Sorry to hear about that. do you know the workspace type you have? This was the list I see on Google's website: support.google.com/docs/answer/12935277?hl=en#zippy=%2Cthese-workspace-editions-can-use-timeline-view Essentials Business Standard Business Plus Enterprise Essentials Enterprise Starter Enterprise Standard Enterprise Plus Education Fundamentals Education Standard Education Plus Business Starter Frontline I checked and it doesn't seem like it is a setting that can be turned off in the Google Admin Portal. This is the article I see for it: workspaceupdates.googleblog.com/2023/05/new-capabilities-timeline-view-google-sheets.html If you do believe you have an account that should have this view, I would recommend checking in with Google's support to see. I think this shows how to contact support, although I've never personally asked them something so I can't say how helpful this would be. support.google.com/a/answer/1047213?product_name=UnuFlow&hl=en&visit_id=638635591938229500-1651767727&rd=1&src=supportwidget0&hl=en Hopefully something here helps troubleshoot this!

Huh interesting! Glad you got it to work! I was testing it and the $C3:$AM3 works and probably is the more sure-proof method! The range locks columns in and goes by rows as you pull it down. The way I showed did work as long as there wasn’t anything in that range before setting up the data validation range down to 1000. If there were different departments/ names on it before adding it seems to pull all names on it as you said! If that happened I was able to just clear the names then it worked as expected. Either way thanks for commenting and glad you got it working as well!

Hmmm. Odd, no I don't think so, but also I am not seeing that still on my end (aka I still get new rows added like the video). Do you happen to have hidden or grouped row by it? that was the only way I could make my table not automatically format to table when I type with what looks like the next row. Otherwise do you happen to be using a different web browser than Chrome? I just know from others Firefox specifically didn't work well with these tables. Otherwise perhaps an update to the browser and /or computer? Sorry not much help probably but hopefully gives a few ideas!

Hey there, great question. It took a bit, but if you highlight the cells you want as the second "Fall 2024" table, then go to Format > Convert To Table, it worked for me to have two different tables together. If you type before formatting them as a table, it just automatically adds to the first table (which is I assume what you had happened as well)! Hope that helps!

Yeah, Mobile isn't updated yet unfortunately. Not sure if/when it will be. I was hoping it would when the full roll out would happen. I did find that if you add a ", " (comma space) between answers, you can get it to select the two, but kind of an annoying workaround.

Hey that's a great question. I had to spend some time testing some things out, and ultimately that isn't a feature with the tables or the Group by View, however it would be a great feature to be added! That said, the easiest thing I found to do this with would be making a pivot table of the table of data and then grouping it by whatever category. I know not the solution to your question exactly, but you can make a pivot table and count with it. Hopefully helps answer your question, feel free to reply if you had questions on it.

Sorry to hear that! The Google blog says September 5th is the scheduled release date for workspace. Not sure if you are using a workspace account or personal? Hopefully it’ll show up for you this week sometime! Only other things I can think of to try is another browser / Chrome or if you are using mobile that doesn’t support it as of now. For browsers, I know Firefox had issues with the new table feature so if you happen to be using Firefox then potentially could be the issue? Chrome should be the one that would work with it, so if you’re using that I think you just have to wait a bit unfortunately to see if/when the option is available to you.

Hi, greetings from the US! Thank you for the comment and greeting. That is a great idea, and while I cannot promise it will happen soon, I will look into what I'd need to do to translate to other languages like Spanish. I agree, there's a lot of people that could be reached with the new features that wouldn't be able to based on the language. If I'm able to get it added, I'll be sure to reach back out to your comment and let you know! Thanks again, and I hope you enjoy the day!

@@matttechtidbits Try to configure the subtitles into Spanish in Settings "Subtitles / Closed Caption

@@SalAbraham7 Hey there, I wasn’t able to get it by following your directions or even the directions on Google’s article, unfortunately. It seems their instructions are outdated from what I see. That said, I was able to, on another account, watch this video to get subtitles auto translated to other languages (including Spanish). I turned on the Closed Captioning button, then hit the settings, then subtitles then auto-translate. That gave numerous languages including Spanish. Not sure if you are able to see that on your side? Hopefully that works for you / others!

No problem! And no, you would just need a Google account with sheets access for this basic series and the intermediate series! I made these video lessons for any type of accounts. I do have some videos that show features only in Google workspace, but it’s in another playlist and I try to make it clear if it is workspace only feature.

@@Sarman-k8n same here!

Glad I could help remind you! Hope it’s a useful new feature!

Hey there, yes you should be able to have multiple tables in a sheet tab! I know some have issues with them if they are close, as they cannot overlap. So just be mindful that they aren’t too close if you need to add more columns or rows. You’ll need to highlight the area you want and right click > format as table. Or use the menu bar option in formatting > format as table. Hope this helps!

Hey, so is this if you have a preexisting unformatted table of data, and when you press "insert table" it goes over the information? If so, I think you need to select the range you want to convert, right click, then select "format as table". Hopefully that is the question, sorry if I misunderstood!

Hey there, yes instead of using the Table1[full_name] as the SELECT statement, you would either need to use the column number. So Something like =QUERY(Table1[#ALL],"SELECT Col1,Col2,..." OR you can use whatever the Column letters are. So, =QUERY(Table1[#ALL],"SELECT A,B,..." For QUERY, it can only can use the table as the data to query from. Hopefully this helps for your question! Another thing if you are using it with FILTERS, or you don't want the header row, I just saw you can reference just "Table1" which does everything except the header row. Which matches what the Table1[first_name] has been doing. Just in case you didn't use FILTER due to mismatched sizes.

Hey there. Yes that is expected behavior, assuming you are just typing below it and the table range expands down to that row you are writing on. It doesn't automatically add rows as you go down, but instead formats that row to the table. So you would need to insert more rows - either right click the row number > insert row, or you can use the keyboard shortcuts: MAC: Ctrl + Option + i, press r then b PC: in Google Chrome: Alt + i, then w PC in other browsers: Alt + Shift + i, then w That said, I would recommend using a new sheet for a new table, or have them in different columns, assuming more rows would be added compared to more columns. That's probably the easiest way, but also know depending on the setup may not be ideal. Hope something here helps!

@@matttechtidbits thank you!!

Hey, thanks glad it was helpful to you! As for your question, it seems like placeholder are not editable at this point unfortunately. This is assuming the placeholders like ## under a column that is a number, or m/d/yyyy for dates. I did check quick and on support.google.com/docs/answer/14239833?hl=en&sjid=3831749139336395473-NC the article sort of confirms this, although not specifically to your question: "For some column types, placeholder chips are auto populated to allow for easy data entry. To turn off placeholder chips for a column". To me, the auto populated makes it sound like it is more meant to give a quick view to users on what should be entered in the columns. You could put that in a feature request as that would be something I see could be useful to others! A potential alternative solution could be adding a data validation rule to only allow dates in a range of dates or before/after a specific date. I did put a video out going through these number data validation rules if that is something you wanted to explore: ruclips.net/video/WmLZV0_EUDo/видео.html

Hi, yes I used these for the “form response 1” and does work. When new entries are added, they are added to the table!

1. Yes I am and yes to the left side! 2. How or what indicated that to you? I’m just genuinely curious…and also impressed!

​@@matttechtidbitsat 16:12 you sprinkled "j" over the sheet while moving your cursor. Your right index finger falls on the "J" key when it's on the home row. So, you must have used your left hand to use your mouse, which would be convenient to place to the left. Otherwise, if you were to use your right hand to use your mouse and spam a letter, your left hand wouldn't have troubled to reach the "J" key; you would have just pressed "F" key. I really felt like Sherlock.

That’s amazing. Totally makes sense. I was guessing hearing clicks of mouse on left side or something with the audio. I hope you do some mystery writing or something!

Of course, thanks for watching! At this point, and from what I’ve seen, we cannot reference it as the table. you still can the “regular way” by referencing the cells. I think that would be a great addition! If you use the “send feedback” button from the table hopefully enough of us request it to be added soon!

Hey thanks for the response! I’ll try to do more new feature videos (unless something else what what you liked about this one) 😁

Hey Great question, from my knowledge right now, (and checking the Release Notes developers.google.com/apps-script/docs/release-notes ) there doesn't seem to be a way to reference the table other than what we'd do previously with getRange or referencing cells. Hopefully Google will add that soon. Using the "send feedback" may help speed that up if enough people request it!

Hey thanks for watching, sorry to hear that one isn't working. A few of things I can think of to try and see what may be going on: 1. can you use =a1 and does it pull either TRUE or FALSE? If so, then the cell reference would be correct and shows what you would look for when the checkbox is selected or not. 2. regions differ with delimiters so instead of the comma ( , ) between A1 and TRUE does a semicolon ( ; ) work for you? so, =COUNTIF(A1;TRUE) 3. I am not sure if you are hoping to count all checked boxes in column A, the COUNTIF syntax is a range, so your current formula would show only a count of 0 or 1 since it is only a single cell (a1) if you used a range like =COUNTIF(A1:A100,TRUE) this should count all cells within A1 to A100. 4. If these don't work, could you hover over the error to see what it reads? That can help hone in what the specific error is. Hope one of these helps!

​@@matttechtidbits Thank you for taking the time to respond to my comment. I finally found the problem ! By default, the display language on my Google Sheet is in French (because i'm french 😀) , so I specified to always use the function names in English. However, since the regional settings were set to France, the argument separators are different. For example, =COUNTIF(A1, TRUE) should be =COUNTIF(A1; TRUE). Thank you very much for taking the time to respond to me, and sorry for the inconvenience. Perhaps we both will have learned something 😅

Yeah for sure. Using it for a bit longer now, another bummer is that formulas cannot be in the header row. Nice step forward with this, but hopefully a lot more added to them! Hopefully using the Send Feedback (down arrow by table name> Send Feedback) we’ll see some more feature like this!

Right?? Yeah not quite the level of Excel’s tables but hopefully the start to bridge that gap!

@@matttechtidbits I also wonder why the don't have Data Solver, and more options in Paste special!

You are welcome, glad it is useful to others!

Hi, great question! At this point it seems like we cannot embed unfortunately - at least based on how you can with, say, a graph. You could still use the "publish sheet" to be able to see the table range. Hopefully that will be a feature coming out sometime!

@@matttechtidbits Bummer. I was really expecting a special embed ability for these. I was going to embed on my Google Sites and enjoy the Notion-like management. I already submitted my feedback on the Sheet. Thanks for sharing the copy.

Hey great question. To my knowledge and trial, no not at this point unfortunately. I’m not an expert in scripts, but I tried referencing a table in a script I’ve use regularly and didn’t recognize that as a valid range. I also don’t see any news about new script options, but hopefully soon it will be possible!