#googlesheetstutorial
LightNews LightNews
spencerssheets.bsky.social
youtu.be/xBO_Z5IXSCc

Google Sheets Troubleshooting: Extend Existing DATEDIF() Formula Down a Column

Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG...

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets Troubleshooting: Extend Existing DATEDIF() Formula Down a Column
YouTube video by Spencer Teaches Sheets
youtu.be
September 3, 2025 at 6:11 AM
spencerssheets.bsky.social
The Freeze submenu in the View menu has an option to freeze up to the current Row or Column to keep everything until then visible as you scroll around a sheet.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
August 21, 2025 at 11:48 PM
spencerssheets.bsky.social
The Freeze submenu in the View menu has default options to freeze 1 or 2 rows and columns, making it very easy to keep a row or a column visible as you scroll around.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
August 21, 2025 at 11:46 PM
spencerssheets.bsky.social
youtube.com/shorts/lt506...

With the SPLIT() function simply give it text and what to use as separator and you can split single-cell text into multiple cells.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
Google Sheets Basics: SPLIT() function
YouTube video by Spencer Teaches Sheets
youtube.com
August 20, 2025 at 4:45 AM
spencerssheets.bsky.social
youtube.com/shorts/wYz_n...

Data / Cleanup / Remove Duplicates can be used as a trick to remove blanks from a column, so long as there is no actual data repeated

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Remove Blanks with the DATA menu
YouTube video by Spencer Teaches Sheets
youtube.com
August 19, 2025 at 4:52 AM
spencerssheets.bsky.social
youtube.com/shorts/PrEzl...

Allow user input without seeing the formulas using 3 files: An input, formulas, and middle with IMPORTRANGE between them

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Hide Formulas with IMPORTRANGE
YouTube video by Spencer Teaches Sheets
youtube.com
August 13, 2025 at 5:06 PM
spencerssheets.bsky.social
youtube.com/shorts/PsK4B...

When you copy and paste a cell over a range each cell gets the exact value. To increment the value on each cell simply drag the fill handle!

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Automatically Increment using Fill Handle
YouTube video by Spencer Teaches Sheets
youtube.com
August 7, 2025 at 10:14 PM
spencerssheets.bsky.social
youtube.com/shorts/NXiql...

Use COUNTA() as the input to the CHOOSE() index to easily return a value based on how many items are in a range.

Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Choose a Value based on Count
YouTube video by Spencer Teaches Sheets
youtube.com
August 7, 2025 at 6:12 AM
spencerssheets.bsky.social
youtube.com/shorts/nQqO7...

While there is a technical definition for a number being Even, Sheets provides the easy functions ISEVEN() and ISODD().

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Check if a Number is Even or Odd
YouTube video by Spencer Teaches Sheets
youtube.com
August 5, 2025 at 6:45 AM
spencerssheets.bsky.social
youtube.com/shorts/24YKk...

With a column of data generated by a formula where some of the data is incorrect, outdated, or just wrong use a helper column to override

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Override Formula Output with Manual Data
YouTube video by Spencer Teaches Sheets
youtube.com
August 2, 2025 at 7:50 PM
spencerssheets.bsky.social
youtube.com/shorts/YWeGS...

To highlight entire rows without checked boxes, join all the values in the row and check for the value TRUE in the joined value

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Highlight Rows with No Checked Boxes
YouTube video by Spencer Teaches Sheets
youtube.com
August 1, 2025 at 5:21 AM
spencerssheets.bsky.social
youtube.com/shorts/BTVau...

Sometimes it makes sense to multiply all checkboxes in a row by a value. Do this with the BYROW() function surrounding COUNTIF()*val

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Multiply Checkboxes by a Value Row-by-Row
YouTube video by Spencer Teaches Sheets
youtube.com
July 31, 2025 at 7:13 AM
spencerssheets.bsky.social
youtube.com/shorts/wABxs...

You can easily sort a range on 2 columns at once by using the Advanced Sorting Options from the Data menu

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Multidimensional Sort
YouTube video by Spencer Teaches Sheets
youtube.com
July 24, 2025 at 5:59 AM
spencerssheets.bsky.social
youtube.com/shorts/ynGR4...

The Filter Tool on the Toolbar allows you to sort a range by a single column, either ascending or descending.

Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Use the Filter Tool to Sort
YouTube video by Spencer Teaches Sheets
youtube.com
July 21, 2025 at 9:22 PM
spencerssheets.bsky.social
youtube.com/shorts/Snipy...

Simple calculations like [range]*-1 can simply be done down a column using the ARRAYFORMULA() function around the calculation.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Use ARRAYFORMULA to Perform a Simple Calculation Down a Column
YouTube video by Spencer Teaches Sheets
youtube.com
July 20, 2025 at 6:21 AM
spencerssheets.bsky.social
youtube.com/shorts/5kJ-h...

Return 1 row per unique ID (the Rep in this case), the count of each, and the sum of service amounts, all in a single QUERY formula.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: COUNT and SUM in QUERY
YouTube video by Spencer Teaches Sheets
youtube.com
July 13, 2025 at 6:11 AM
spencerssheets.bsky.social
youtube.com/shorts/x8C2l...

HSTACK appends ranges together so MAP(LAMBDA(HSTACK(COUNTIF(),SUMIF()))) outputs 2 columns of formula output from a single formula!

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Use HSTACK to Fill 2 Columns at Once from Different Formulas
YouTube video by Spencer Teaches Sheets
youtube.com
July 10, 2025 at 5:41 AM
spencerssheets.bsky.social
youtube.com/shorts/UGTay...

Sheets automatically recognizes contiguous data for things such as new formulas and Alternating Colors

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets Basics: Automatically Recognizing Contiguous Data
YouTube video by Spencer Teaches Sheets
youtube.com
July 9, 2025 at 5:53 AM
spencerssheets.bsky.social
youtube.com/shorts/sXd47...

Use ISBLANK() in an IF() function to check if a cell is blank and value_if_false to do whatever you want to do if the cell isn't blank.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Use =IF(ISBLANK()) to Test if a Cell Contains Data
YouTube video by Spencer Teaches Sheets
youtube.com
July 2, 2025 at 6:13 AM
spencerssheets.bsky.social
youtube.com/shorts/kOL5x...

=IF() evaluates 0 as FALSE and all other numbers as TRUE, so we can use the number returned from LEN() to do T/F if a cell contains data.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Use =IF(LEN()) to test if a cell contains data
YouTube video by Spencer Teaches Sheets
youtube.com
June 29, 2025 at 5:56 AM
spencerssheets.bsky.social
youtube.com/shorts/S27y3...

Create a Data Validation rule with a custom =COUNTIF() formula to only allow each number to be used once in a range

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
Google Sheets: Only Allow Unique Numbers
YouTube video by Spencer Teaches Sheets
youtube.com
June 26, 2025 at 5:23 AM
spencerssheets.bsky.social
youtube.com/shorts/_cZf1...

=LEFT(A1,FIND(":",A1)-1) returns everything before a given character. This works for any character and SEARCH() as well as FIND().

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
Google Sheets: Return Everything Before a Character
YouTube video by Spencer Teaches Sheets
youtube.com
June 20, 2025 at 6:08 AM
spencerssheets.bsky.social
youtube.com/shorts/1bbk5...

Use the construction =RIGHT(A1,LEN(A1)-FIND(":",A1)) to remove everything up to and including a particular character.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
Google Sheets: Remove Everything Before a Character
YouTube video by Spencer Teaches Sheets
youtube.com
June 19, 2025 at 5:41 AM
spencerssheets.bsky.social
youtube.com/shorts/8RPXM...

Google Sheets: Track Time Overnight

24 hours is equal to the number 1, so just add 1 to the Clock Out time if the out time is earlier than the in time.

CORTEXX
open.spotify.com/artist/4fOVG...

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
Google Sheets: Track Time Overnight
YouTube video by Spencer Teaches Sheets
youtube.com
June 13, 2025 at 5:52 AM
spencerssheets.bsky.social
youtube.com/shorts/dqCMx...

Use negative offset_rows and _columns along with [height] and [width] to return a rectangular array of values.

CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2

#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide #starwars
Google Sheets: Offset Surrounding Cells
YouTube video by Spencer Teaches Sheets
youtube.com
June 10, 2025 at 5:33 AM