Відео

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: ua-cam.com/video/WmLZV0_EUDo/v-deo.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!