Sheets By Olan
@sheetsbyolan.bsky.social
Google Sheets > Excel 🙃
Templates, formulas, tips, etc.
120K+ on TikTok
Widescreen on YouTube
Brooklyn, NY
sheetsbyolan.com
Templates, formulas, tips, etc.
120K+ on TikTok
Widescreen on YouTube
Brooklyn, NY
sheetsbyolan.com
Add recurring tasks to your Automated Task Tracker automatically when you click a button! By default, there’s a time based trigger that automatically adds any recurring tasks that need to be completed to your task tracker each night. This is an optional customization that allows you to deactivate
September 18, 2025 at 1:58 PM
Add recurring tasks to your Automated Task Tracker automatically when you click a button! By default, there’s a time based trigger that automatically adds any recurring tasks that need to be completed to your task tracker each night. This is an optional customization that allows you to deactivate
Automated is always better BUT sometimes you’re job has firewalls that block the automation. I’d this is you, this non automated task tracker will help you stay organized with minimal effort! There’s a full tutorial showing how to build this task tracker from scratch on my YouTube channel or
September 17, 2025 at 12:54 PM
Automated is always better BUT sometimes you’re job has firewalls that block the automation. I’d this is you, this non automated task tracker will help you stay organized with minimal effort! There’s a full tutorial showing how to build this task tracker from scratch on my YouTube channel or
Allow recurring tasks to be added to your Automated Task Tracker by removing the weekend blocker! This will work in both the Google Sheets and Excel versions #tasktracker #templatecustomization #googlesheets #excel
September 16, 2025 at 12:00 PM
Allow recurring tasks to be added to your Automated Task Tracker by removing the weekend blocker! This will work in both the Google Sheets and Excel versions #tasktracker #templatecustomization #googlesheets #excel
Advanced formulas I used in real life in Google Sheets: Embed formulas into the header ! There are some use cases where this is incredibly useful and can simplify things but a majority of the time, this is completely optional. That being said it will keep your formulas clean and since it’s in the
September 15, 2025 at 11:53 AM
Advanced formulas I used in real life in Google Sheets: Embed formulas into the header ! There are some use cases where this is incredibly useful and can simplify things but a majority of the time, this is completely optional. That being said it will keep your formulas clean and since it’s in the
Advanced formulas I used in real life in Google Sheets: ARRAYFORMULA! ARRAYFORMULA has a couple of uses. By default it applies a formula to the whole column and returns a single value. It works this way in both Google Sheets and Excel. In Google Sheets it has an additional function where you can
September 12, 2025 at 12:56 PM
Advanced formulas I used in real life in Google Sheets: ARRAYFORMULA! ARRAYFORMULA has a couple of uses. By default it applies a formula to the whole column and returns a single value. It works this way in both Google Sheets and Excel. In Google Sheets it has an additional function where you can
Advanced formulas I used in real life in Google Sheets: IMPORTRANGE! For context I’m a Revenue Operations Director but if you use spreadsheets IMPORTRANGE will come in handy more than you think. In short, IMPORTRANGE allows you to create a live sync between spreadsheets. This can simplify
September 11, 2025 at 12:02 PM
Advanced formulas I used in real life in Google Sheets: IMPORTRANGE! For context I’m a Revenue Operations Director but if you use spreadsheets IMPORTRANGE will come in handy more than you think. In short, IMPORTRANGE allows you to create a live sync between spreadsheets. This can simplify
Quickly translate text directly in Google Sheets! #googlesheets #googletranslate #smallbusinessowner #spreadsheettips
September 5, 2025 at 12:17 PM
Quickly translate text directly in Google Sheets! #googlesheets #googletranslate #smallbusinessowner #spreadsheettips
Quickly translate text directly in Google Sheets without knowing the origin language! #googlesheets #googletranslate #smallbusinessowner #spreadsheettips
September 4, 2025 at 12:17 PM
Quickly translate text directly in Google Sheets without knowing the origin language! #googlesheets #googletranslate #smallbusinessowner #spreadsheettips
Chip & Reference HACK in Google Sheets! #googlesheets #googlesheetshack #spreadsheettips
September 3, 2025 at 1:10 PM
Chip & Reference HACK in Google Sheets! #googlesheets #googlesheetshack #spreadsheettips
Easily update the vibe of your spreadsheet with Themes in Google Sheets! #googlesheets #theme #colors #googlesheetstips
September 2, 2025 at 12:04 PM
Easily update the vibe of your spreadsheet with Themes in Google Sheets! #googlesheets #theme #colors #googlesheetstips
How to add a second deadline calendar to your Automated Task Tracker in Google Sheets! #googlesheets #tasktracker #customtemplate
August 30, 2025 at 12:06 PM
How to add a second deadline calendar to your Automated Task Tracker in Google Sheets! #googlesheets #tasktracker #customtemplate
How to add a new column to your task tracker in Google Sheets without breaking the automation! #googlesheets #tasktracker #customtemplate #productivitytips
August 29, 2025 at 12:11 PM
How to add a new column to your task tracker in Google Sheets without breaking the automation! #googlesheets #tasktracker #customtemplate #productivitytips
How to create a new trigger in your Automated Task Tracker without breaking the automation in Google Sheets! #tasktracker #customtemplate #template #googlesheets
August 28, 2025 at 12:11 PM
How to create a new trigger in your Automated Task Tracker without breaking the automation in Google Sheets! #tasktracker #customtemplate #template #googlesheets
How to Rename Tabs in your Automated Task Tracker in Google Sheets without breaking the automation! #tasktracker #customtemplate #googlesheets #productivitytips
August 27, 2025 at 1:10 PM
How to Rename Tabs in your Automated Task Tracker in Google Sheets without breaking the automation! #tasktracker #customtemplate #googlesheets #productivitytips
How to reorganize existing columns in your automated task trackers without breaking the automation in Google Sheets! Note: your version will say “Done” instead of completed. If you want to see how to change that check out my video on updating dropdowns! #tasktracker #customtemplate #organization
August 26, 2025 at 12:10 PM
How to reorganize existing columns in your automated task trackers without breaking the automation in Google Sheets! Note: your version will say “Done” instead of completed. If you want to see how to change that check out my video on updating dropdowns! #tasktracker #customtemplate #organization
How to update dropdowns in your Automated Task Tracker in Google Sheets! #tasktracker #googlesheets #excel #customtemplate
August 25, 2025 at 12:09 PM
How to update dropdowns in your Automated Task Tracker in Google Sheets! #tasktracker #googlesheets #excel #customtemplate
Pivot tables are way better than biking over Cobblestone if you ask me #pivottables #googlesheets #excel
August 24, 2025 at 8:15 PM
Pivot tables are way better than biking over Cobblestone if you ask me #pivottables #googlesheets #excel
How to use the FILTER function in real life! Also not sponsored but @LePuzz is my fav puzzles!
August 22, 2025 at 3:10 PM
How to use the FILTER function in real life! Also not sponsored but @LePuzz is my fav puzzles!
COUNTIF in real life! This formula is a core to spreadsheets so it’s a must know! #countif
August 21, 2025 at 11:56 AM
COUNTIF in real life! This formula is a core to spreadsheets so it’s a must know! #countif
Knowing how to PROPERLY reference cells in your formulas is critical when using spreadsheets
August 20, 2025 at 11:57 AM
Knowing how to PROPERLY reference cells in your formulas is critical when using spreadsheets
How to use XLOOKUP in real life! But also that miso vermouth from hits #xlookup #googlesheets #excel
August 19, 2025 at 11:57 AM
How to use XLOOKUP in real life! But also that miso vermouth from hits #xlookup #googlesheets #excel
Who has RSVP’d & who hasn’t? Find out super easily with the FILTER function! #spreadsheettips
August 18, 2025 at 11:55 AM
Who has RSVP’d & who hasn’t? Find out super easily with the FILTER function! #spreadsheettips
Easily constrain filtered ranges to avoid gettting a REF error if the list gets too long!
August 15, 2025 at 11:56 AM
Easily constrain filtered ranges to avoid gettting a REF error if the list gets too long!
Dynamic filtering is easy to set up and even easier to use! #spreadsheet tips dsheet
August 14, 2025 at 11:55 AM
Dynamic filtering is easy to set up and even easier to use! #spreadsheet tips dsheet
How to create spreadsheet content! #contentcreator #googlesheets #excel
August 13, 2025 at 12:59 PM
How to create spreadsheet content! #contentcreator #googlesheets #excel