@@codybess525 hey great question, and yes it should! I used it on my work Microsoft account and it did. All the needed information is there, it just didn’t show as nicely, like not all graphics downloaded correctly.

@@meiling5929 hey great question and I made a video for printing, which you should be able to “print” to PDF. Printing Document Tabs kzbin.info/www/bejne/nmTCn4Z3ic-rn9U Quick instruction to get all tabs printed: you press the 3 dots in Google Drive (not in docs) and then go to quick view, then print from there. Hope that helps!

Yeah it’s a great update! And glad that helped with table of contents, hopefully soon we can automatically do them all without these additional steps!

Hey there, I'm able to move them at least! I have been able to drag them up above the tab they were in to get them out of the subtab. Then dragging one back on a tab makes it into the subtab.

Hey thank you for the comment! I was pretty happy how those turned out! And I use Canva for my graphics / slides, and they have "frames" which allows you to add videos /photos / gifs into them. So I did a phone screen record, then added that inside their phone frame. The iPad background was an image and I just used a rectangle frame inside it to get that set. I used Adobe Premiere for my video editing, which allowed me to make a cleaner cut of the phone/iPad outline within it.

Both are great - better even. To account for incoming data and readability of which ranges are what. I need to make it more of a habit to use the new table referencing!

Hey there, Great question. From my testing, it is sharing the entire document or none of it at this point. That would be a really nice option to have! Even changing permissions like in Google Sheets to have certain Tabs be "view only" to some users could have a use as well. Hopefully an update sometime!

@@matttechtidbits I wondered this also. I wanted to make a doc for my my 10 week course. And have a tab for each day, and then just unlock the tab as needed

Hey that's a great question. I was messing around on mobile and do not see the option to add like you mentioned. So it seems like it isn't available for mobile devices at this point...Hopefully soon it'll be added!

Hey that’s an excellent question. I’ve been playing around more and found that both printing and exporting inside docs/ the tab ONLY does the tab. If you press the 3 dots in Google Drive, then you can print or export the entire doc with every tab. It does change the formatting slightly to include a page for each tab name, then whatever is on that tab.

I'm also a writer and this is an absolute game changer for my notes for books. Really like it so far.

That’s fair. And yeah I agree having the option to toggle between the two for cases like that. It’s silly that this is the option atm, but may be helpful if you are doing a long project, you can hide the element for the button by holding shift > right clicking > inspect, then find the div class for the button and hide it. It’ll highlight the button but it’s the one with “miniChapterSwitcherCore” You’d have to do this every time you refresh and open a doc. So not a great method but again if you are working on a project for a good chunk of time, may help out

Yeah agreed! I should have covered that in the video. The search/ find and replace works as I hoped where you can search a tab or all tabs!

@@matttechtidbits where do you find the option to just search the current tab? seems like it automatically searches all with no way to do just one tab, which is nice sometimes but not great other times.

Yeah it’s a great addition - super excited to get organized 😁

Thanks for hint , this will be very helpful

Hey there, Yeah. I assume it is that you are getting lots of groups based on multiple selections and the order they selected them in? Unfortunately in this case, it's stored as [selected_item_1], [selected_item_2], [selected_item_3], etc. Are you hoping to get the same single selected items grouped, or just that if someone picks 1,2,3 - regardless of order - they are grouped? Either way, I do agree it would be nice to have the option to group by all items or singular items. Not sure if that will be something coming out, however. It's not the same question you have, but I did put a video out and showed a method to pull each item for a count. Not sure if it could help your situation, hopefully it could! kzbin.info/www/bejne/ZoO2ap2heKmZr6cfeature=shared&t=385

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: kzbin.info/www/bejne/jZ6vi4lmlKqIetE

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 😅