Dataful.TechStructured Tables in Google SheetsComplete guide to Tables — Google Sheets’ latest new feature: how to create and configure them, that features they offer, their limitationsJul 4Jul 4
Dataful.TechHow to Insert Multiple Rows and Columns in Google SheetsYou can easily insert one row in Google Sheets by right-clicking on the header and choosing Insert 1 row above / below:May 22May 22
Dataful.TechAccess Google Cloud Secret Manager via Google Apps ScriptThere are many ways to store secrets, such as tokens, passwords, and API keys, in Google Apps Script, but they are not created equal. Some…May 1May 1
Dataful.TechHow to Sort by Multiple Columns in Google SheetsYou often need to sort rows by multiple columns simultaneously to review and analyze the data more efficiently. It is easy to do in Google…Apr 25Apr 25
Dataful.Tech7 Ways to Sort Data in Google SheetsSorting data in Google Sheets is a common task that can help organize and analyze it. There are multiple ways to sort data in Google…Apr 18Apr 18
Dataful.TechHow to Preserve Header Row Position During Sorting in Google SheetsIn this post, we will look at a quick lifehack. If you sort data in Google Sheets via the Main Menu -> Data -> Sort ... as well as the…Apr 9Apr 9
Dataful.TechSecretService: Library for Storing Secrets in Google Apps ScriptLeverage SecretService Library for your Google Apps Script projects to securely store secrets.Mar 12Mar 12
Dataful.TechDropdowns in Google Sheets: Complete GuideEverything you need to know about dropdowns in Google SheetsFeb 6Feb 6
Dataful.TechFILTER function with OR and complex conditionsFILTER is an indispensable and powerful Google Sheets function that allows you to filter data by multiple criteria. By default, all FILTER…Jan 3Jan 3
Dataful.TechBoost Your Google Sheets Productivity with the Name BoxGoogle Sheets’ Name box is my favorite time saver of the year. It is situated to the left of the formula box and, by default, shows the…Dec 15, 2023Dec 15, 2023
