Yagisanatode @yagisanatode@qoto.org

Reconsider Smart Chips when using Apps Script in Google Sheets. @GoogleWorspaceDev Google Developer Experts #GoogleAppsScript #GoogleSheets #GoogleWorkspace https://youtu.be/YQ5SFNXeULE

New Google Chat Quick Commands an alternative to Slash Commands. I give them a spin in Google Apps Script @WorkspaceDevs #GoogleAppsScript #GoogleChat Google Developer Experts

https://youtu.be/AvAYawLx5SU

Offset Gradient Conditional Formatting in Google Sheets with Apps Script #GoogleAppsScript #AppsScript #GoogleWorkspace #GoogleSheets @WorkspaceDevs
https://youtu.be/4koWQysEJC8

A Simple Apps Script Class to Clear & Set Conditional Formatting in Google Sheets #GoogleAppsScript #AppsScript #GoogleWorkspace @WorkspaceDevs
https://youtu.be/coko7zUXsHk

+1 this Bug - Google Workspace Add-on Card Service does not maintain your primary and secondary colour preferences for a number of widgets like footer buttons, checkboxes, radio buttons, toggle buttons, text input borders and legends. https://issuetracker.google.com/issues/380912402 #googleAppsScript

Part 4: Add Conditional Formatting Rules to a Google Sheet Tab with Google Apps Script #GoogleAppsScript #AppsScript #GoogleWorkspace @WorkspaceDevs
https://youtu.be/efKql-S5fXE

Part 2: Remove a conditional formatting rule WITHIN a range in Google Sheets with Google Apps Script #GoogleAppsScript #AppsScript #GoogleWorkspace @WorkspaceDevs
https://youtu.be/eOkwBwm_76I

Remove a conditional formatting rule by the exact range in Google Sheets with Google Apps Script #GoogleAppsScript #AppsScript #GoogleWorkspace @WorkspaceDevs
https://youtu.be/kJoWhXyYzWQ

Update multiple Apps Script projects from a single source with CLASPALL CLI tool. #GoogleAppsScript #AppsScript #GoogleWorkspace @WorkspaceDevs
https://youtu.be/Avndw9t6StM

Part 3 of the Append a Range of Data from one location in a Sheet to another with Google Apps Script. In this final tutorial, we handle for messy data that may cause other approaches to fail. #GoogleSheets #GoogleWorkspace @WorkspaceDevs

https://youtu.be/idX4CzDepFI #GoogleAppsScript

A Better Financial Year Formula In Google Sheets #GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdmin #GoogleAppsScript #financialYear @WorkspaceDevs
https://yagisanatode.com/a-better-financial-year-formula-in-google-sheets/

Get the last value in a range in Google Sheets #GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdmin #GoogleAppsScript @WorkspaceDevs
https://www.youtube.com/watch?v=9JGiO5_lqF8t/

Prevent consecutive clicks of Google Sheets Image Buttons in with Lock Service and Google Apps Script #GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdmin #GoogleAppsScript @WorkspaceDevs
https://yagisanatode.com/prevent-consecutive-clicks-of-google-sheets-image-buttons-in-with-lock-service-and-google-apps-script/

Now choose to display ALL selected Shared Drive folders OR only those created by you in the Product version of 'List all Files and Folders in a Google Drive Directory in Google Sheets'

https://yagisanatode.com/products/product-list-all-files-and-folders-in-a-google-drive-directory-in-google-sheets/

#GoogleSheet #GoogleAppsScript #AppScript @WorkspaceDevs

Generate UUIDs in Google Sheets with Apps Script (Unique IDs)

#GoogleSheet #GoogleAppsScript #AppScript @WorkspaceDevs

https://youtu.be/xHTY6uZ1KuQ

Sort Sheet Tabs by Date in Google Sheets with Apps Script

#GoogleSheet #GoogleAppsScript #AppScript @WorkspaceDevs

https://youtu.be/Uvd6JjKqVCM

Update and Replace data in files like Text files, HTML, XML, JSON, and JS files in a Google Drive with Apps Script

#GoogleAppsScript #AppsScript #GoogleDrive #GoogleWorkspace @WorkspaceDevs

https://youtu.be/mi6Wb-da-GQ

Use HTML files stored on Google Drive in Apps Script web apps, dialogues and sidebars for Google Workspace. #GoogleAppsScript #GoogleWorkspace #WorkspaceDev
https://youtu.be/6o1VS23hNTo

Extract CELL Background & Font Colours in Google Sheets with Apps Script #GoogleSheets #GoogleWorkspace #Spreadsheets #BusinessAdmin #GoogleAppsScript @WorkspaceDevs
https://youtu.be/rD2S4cqyf1c

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

https://youtu.be/HAx1LfcxdRA