Remove Empty Cells from Google Sheets QUERY
#GoogleSheets #Spreadsheets #GoogleWorkspace #BusinessAdmin #BusinessManagement
Google Sheets QUERY by dates
#GoogleSheets #Spreadsheets #GoogleWorkspace #BusinessAdmin #BusinessManagement
Extract CELL Background & Font Colours in Google Sheets with Apps Script #GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdmin #GoogleAppsScript @WorkspaceDevs
https://youtu.be/rD2S4cqyf1c
Google Sheets FILTER function Dates by Weekday or Weekend. Part 4 of the accompanying written tutorial on the FILTER function and dates and times. #GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdmin
https://youtu.be/kig03gNtO2A
Google Sheets FILTER function with Date Time Stamps is now out. Part 3 of the accompanying written tutorial on the FILTER function and dates and times with BONUS section where we use FILTER to filter any DTS after a specific time. #GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdmin
https://youtu.be/dsNVgw6rxGM
Google Sheets FILTER function and TIMES video is now out. Part two of the accompanying written tutorial on the FILTER function and dates and times. #GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdmin
https://youtu.be/ObgFUvty2vU
Google Sheets FILTER function and DATES video is now out. Part one of the accompanying written tutorial on the FILTER function and dates and times. #GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdmin
https://youtu.be/OUFvHW5sjUo
Copy and Paste Row Heights in Google Sheets with Apps Script. This is a surprisingly tricky and process-costly task. Learn how to do it efficiently while not falling for some common issues. @workspacedevs #GoogleAppsScript #GoogleSheets #GoogleWorkspace
Copying Ranges in Google Sheets with Apps Script - Part 4 in the beginner-friendly series on copying Sheets, Tabs and Ranges in #GoogleSheets with #GoogleAppsScript. Check it out!
@workspacedevs #googleworkspace #businessautomation
Duplicate Google Sheets Tabs into other Spreadsheets with Apps Script.
Copy to:
1) a new Google Sheet,
2) an existing Google Sheet,
3) All tabs,
4) Selected tabs and
5) Except for certain tabs.
Beginner friendly. 🧸
@workspacedevs #GoogleAppsScript #GoogleSheets #GoogleWorkspace
Learn how to copy sheet tabs within the same Google Sheet with Google Apps Script.
This is a beginner-friendly series on duplicating Google Sheets, Sheet tabs and ranges with Apps Script.
@workspacedevs #GoogleAppsScript #GoogleSheets #GoogleDrive #Spreadsheets #SpreadhseetAutomation
https://youtu.be/xDwWA57kArI
Make a Copy of a Google Sheet with Apps Script.
Part of a series on duplicating Google Sheets, Sheet tabs and ranges with Apps Script.
If you are new to Apps Script this is ideal for you.
@workspacedevs #GoogleAppsScript #GoogleSheets #GoogleDrive #Spreadsheets #SpreadhseetAutomation
Add the Editor's Email when they Tick the Check Box in Google Sheets with Apps Script - This tutorial came from a discussion with an attendee at the Google Workspace Developer Summit 2023 in Singapore last week.
If you and your team are working in a Google Workspace Domain account (Paid Version) this handy onEdit() automation might shave some admin time off your work for you. Enjoy!
Contains a written and a video tutorial with a starter Google Sheet to play along.
@workspaceDevs #GoogleAppsScript #GoogleSheets #GoogleWorkspace #SpreadsheetAutomation #BusinessAdministration #GoogleWorkspaceDeveloperSummit
Sort a Range Matrix from Left to Right and Top to Bottom in Google Sheets
I've torn myself away from Baldur's Gate 3 long enough to create this D&D-inspired tutorial on creating a Reduced Choice Dropdown Data Validation in Google Sheets with Apps Script. Enjoy!
#GoogleAppsScript #GoogleSheets #DataValidation @workspacedevs
https://www.youtube.com/watch?v=XFEvYlpK7nw
How does MAKEARRAY work in #GoogleSheets? Let's build and shuffle a deck of cards and find out. 🃏♥♦♠♣
Need to convert a column of data to a 2d range or convert a 2d range to a column? In this tutorial, we cover how to stack and unstack data in Google Sheets
#GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdministration
Reverse Ranges by Columns or Rows in Google Sheets (Flip)
#GoogleSheets #GoogleWorkspace #spreadsheets #businessadministration
REVERSE_ROWS and REVERSE_COLS have now been added to the #GoogleSheets Named Function Pack. You can find out more here: https://yagisanatode.com/products/named-function-pack/
Prevent editors from modifying a dropdown list in Google Sheets with Apps Script https://youtu.be/SQIq99L8MXE @workspacedevs #googleappsscript #GoogleSheets #GoogleWorkspace
Learn how to retrieve existing Dropdown from a Range Data Validation rules in Google Sheets using Google Apps Script by creating a a macro that prevents other editors from modifying a dropdown list in Google Sheets with Apps Script.
Google Developer Expert & Google Cloud Champion Innovator in Google Workspace at Yagisanatode