Skip to content
Sheetsnerd.com logo

Google Sheets Nerd

  • Home
  • Latest
  • About
  • Contact
Sheetsnerd.com logo
Google Sheets Nerd

Latest Google Sheets Tips and Tricks

How to use GoogleTranslate() with Arrayformula()
Formulas for Google Sheets and Excel (from beginner to advanced)

How to use GoogleTranslate() with Arrayformula()

Bysnadmin May 18, 2023May 18, 2023

Using GoogleTranslate in array formulas in Google Sheets.

Read More How to use GoogleTranslate() with Arrayformula()Continue

How to Host a Web Page on Google Apps Script
Google Apps Script | Uncategorized

How to Host a Web Page on Google Apps Script

Bysnadmin March 24, 2023March 24, 2023

How to host a web page / web site for free in Google Apps Script.

Read More How to Host a Web Page on Google Apps ScriptContinue

Convert a Date to FY-Quarter format for the July-June Financial Year
Formulas for Google Sheets and Excel (from beginner to advanced)

Convert a Date to FY-Quarter format for the July-June Financial Year

Bysnadmin February 18, 2023February 18, 2023

How to convert dates to FY-Quarter format for the July-June financial year.

Read More Convert a Date to FY-Quarter format for the July-June Financial YearContinue

Automatically Populate a Row of Data When Adding New Items to a Column
Google Apps Script

Automatically Populate a Row of Data When Adding New Items to a Column

Bysnadmin February 10, 2023February 10, 2023

How to automatically populate data when adding a new value to a column.

Read More Automatically Populate a Row of Data When Adding New Items to a ColumnContinue

How to Sort Sheets and Create an Index (with Google Apps Script)
Google Apps Script

How to Sort Sheets and Create an Index (with Google Apps Script)

Bysnadmin November 12, 2022November 12, 2022

Using Google Apps Script to sort sheets and to create an index of every sheet in a document.

Read More How to Sort Sheets and Create an Index (with Google Apps Script)Continue

How to Underline in Google Sheets
Formatting in Google Sheets / Excel

How to Underline in Google Sheets

Bysnadmin August 28, 2022August 28, 2022

How to Underline in Google Sheets — a few quick and easy ways to do it.

Read More How to Underline in Google SheetsContinue

How to Sum a Column in Google Sheets
Formulas for Google Sheets and Excel (from beginner to advanced)

How to Sum a Column in Google Sheets

Bysnadmin August 24, 2022August 24, 2022

How to sum a column in Google Sheets — multiple ways, including a quick shortcut.

Read More How to Sum a Column in Google SheetsContinue

How to Add Stacked Bar Totals in Google Sheets and Excel (an easier way)
Charts

How to Add Stacked Bar Totals in Google Sheets and Excel (an easier way)

Bysnadmin December 31, 2021April 9, 2022

How to make stacked bar totals in Google Sheets.

Read More How to Add Stacked Bar Totals in Google Sheets and Excel (an easier way)Continue

Build An API in Google Sheets and Google Apps Script
Google Apps Script

Build An API in Google Sheets and Google Apps Script

Bysnadmin December 28, 2021December 31, 2021

How to build a whole API in Google Sheets, sourcing data from a Google sheet you write, and retrieving it via HTTP Get.

Read More Build An API in Google Sheets and Google Apps ScriptContinue

How to use Google Sheets as JSON Database  for Web Apps
Google Apps Script

How to use Google Sheets as JSON Database for Web Apps

Bysnadmin December 27, 2021November 21, 2022

How to use Google Sheets as the back-end database for a web application, producing JSON.

Read More How to use Google Sheets as JSON Database for Web AppsContinue

Page navigation

1 2 Next PageNext

© 2023 Google Sheets Nerd - WordPress Theme by Kadence WP

  • Home
  • Latest
  • About
  • Contact