✨ Google Sheets Introduces Tables

[@OrcForge]

This is gonna help me create my first CRM so quick THANK YOU

[@MélodieVaury]

Amazing tutorial, exactly what I needed! Thank you!

[@danleeman]

Hey, thanks for watching. Let us know if you need help building your projects. Feel free to book a consultation call 👉 leeman.io/free-call Subscribe to the channel!

[@StudioBugBX]

I also want to thank you for the tutorial on this. I was just about to reinvent the world and the feature they have given us is so easy to use. Blessings!!🤩

[@mpbeauvais]

Great tutorial. Thank you for making it concise and very easy to understand through visualization.

[@geoffroyc]

Thanks man, great video! Well explained, detailed, and quick. Good stuff.

[@engreubenkitilya]

Thank you so much for sharing this

[@LUNTK]

Thanks for making this video! Does anyone know if people that I assign tasks to, get notified about it or does this specific task show up somewhere in their inbox/some google application? Or do they have to specifically go inside of the sheets app, in order to see which task they're assigned to?

[@LUNTK]

Is there any way to change the grid view to something like a kanban view?

[@jeanpierre1108]

Same here! Have you already get the answer? lol

[@EastTactics]

how do I at totals to either the whole table... or even the groups once expanded out?

[@smaarwa]

I have been trying to add multiple tables to the same work sheet, not sure if that's possible.

[@GoingGreenMom]

Soooo, am I correct in understanding that they are basically just making a prettily formatted table within the table that is the spreadsheet?

[@sliiiin]

... and easy referencing to the columns, which is the main benefit

[@GoingGreenMom]

@sliiiin can you explain what you mean? On mine they appear to have the same column referencing as before?

[@JuanGutter]

Hi there, thanks for the video. Can you hide columns for specific audiences?

[@bhadawang]

I'll try this, Thank's Dan

[@ely_rimando]

Do you have a video on inserting charts using the data in google sheet table? Also, how to use the extensions tab like appsheet, app scripts, macros and looker studio. Appreciate this thank you.

[@maryanncandelaria1123]

Hi Dan, I'd like to create a table that will display the weekly data for every client. Do you have a video tutorial for this? Thank you!

[@SPQRiTalian90]

interesting.. .I wonder if they will integrate more features from google tables into sheets

[@igomesigomes]

Nice video. But I wonder how can I pass the value of a column of the same cell row using the "table[column name]" notation, to use this value in a function call. If I use "table[column name)" as a parameter in FILTER as a condition, it passes the complete range for the function. Any help would be apreciated.

[@1TreukFlyyy]

Any idea on how to get subtotal (sum of numeric column) when grouping by view ?

[@EastTactics]

Same!! how could they over look not allowing for subtotals in a column with this new feature? Guess im back to using pivot tables

[@stevengergi6781]

Well Add a row on top write =subtotal(109, " your range". Done

[@johndaniel21343]

It's interesting, still don't understand why Google don't offer and app like airtable and notion. A place you can have a form view to edit data, sometimes in a spreadsheet is no fun

[@JonathanBradshaw-k5c]

Airtable has entered the chat

[@trinitytythegiftcardguy]

is this also for mobile?

[@zainulfanani]

How this affecting appsheet?

[@pressrepeat2000]

What software is this similar to? Airtable?

[@ServantStatusMinistries]

Yea that and click up, asana, baserow…

[@pressrepeat2000]

@@ServantStatusMinistries Cool. Does Microsoft or Apple have anything similar?

[@ServantStatusMinistries]

@@pressrepeat2000 that I’m not too sure. I believe Microsoft is focusing more on their app Microsoft loop that has these abilities. Coda is another one but I don’t know if Apple has something similar

[@georgedouglasmcfly2598]

Microsoft Loop and Microsoft Lists, but really limited features and not super user friendly

[@pressrepeat2000]

@@georgedouglasmcfly2598 Which one do you think is better?

[@milovo164]

So how to insert a Normal collumn right next to the Table but not turn it into a table's collumn?

[@dimichaelangelofamilydenti6999]

can we integrate bots?

[@danleeman]

@@dimichaelangelofamilydenti6999 Sure, with an integration platform or Apps Script

[@AtanasLambew]

Have a table forms?

[@akzabowtme]

i hope they make this better as time goes, would love to just use sheets instead of airtable and sheets and zapier etc etc

[@KamalAmziane]

Thanks

[@zamorvex]

it keeps saying i have put an invalid table name even though i only put letters

[@youneshamza381]

Ur great

[@alexsmedile]

Missing relations and tagging

[@hom-sha-bom]

I still don't really get why i would use a table instead of just a normal spreadsheet

[@altuno]

This still has some bugs, for example added 50000 lines to the worksheet when i wanted to convert a table into this new format. I suggest wait and see before anyone uses this for a serious project.

[@creativityX]

Go Notion

[@TheBialbino]

Almost a Power Query... Keep trying, Google.... I' d like to see...

[@jrosmail]

😂😂😂 now?? Really ? So many years ago should have had that

[@JohnTurner313]

Looks like they reinvented Microsoft Access.

[@FranzAllanSee]

They’re trying to copy airtable

[@barking_mad6649]

MS List. But it works from inside Sheets, unlike Lists which doesn't work from inside Excel

[@JordiVallsribas]

they bought a startup doing this so they couldnt be accused to copy airtable

[@uaer309]

Airtable is overpriced anyway

[@HippieP629]

Tables, sure. For proj mgmt? Absolutely not

[@danleeman]

You use unstructured data for project management?

[@danleeman]

I think you may have misunderstood my point, people all over the world use Google Sheets for project management. I don't think that's optimal, I think one should use a PM system. But, if you're going to use Google Sheets anyways, better to have structured data and baked in views rather than a vanilla sheet.

[@HippieP629]

@@danleeman My thought, in general, is that there's actual proj mgmt platforms. ACTUAL proj mgmt platforms. It's taken Google how many yrs to add a table? That's laughable lol If my next job used Google sheets as task mgmt I'd quit

[@danleeman]

@@HippieP629 Totally agree with that - not trying to convince people to use this instead. However, for all the people already using Sheets for this (a ton) either they don't have budget, it's ad hoc, etc., then this a better option that using Google Sheets without Tables

[@divyv20]

Hey Dan ! I loved this video . I work with entrepreneurs like you who have under 15k followers to help them to grow to 100k followers in under 12 months with proper systems . I actually helped Chirag to achieve 92k subscribers in under 11 months . Could I do a free audit to see if I can help you do the same ? I just think it's really important that more people see your content and want to help you on that mission .