Author | Lightnews

Sheets By Olan @sheetsbyolan.bsky.social · Sep 18

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

Sheets By Olan @sheetsbyolan.bsky.social · Sep 17

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

Sheets By Olan @sheetsbyolan.bsky.social · Sep 16

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

Sheets By Olan @sheetsbyolan.bsky.social · Sep 15

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

Sheets By Olan @sheetsbyolan.bsky.social · Sep 12

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

Sheets By Olan @sheetsbyolan.bsky.social · Sep 11

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

Sheets By Olan @sheetsbyolan.bsky.social · Sep 5

Quickly translate text directly in Google Sheets! #googlesheets #googletranslate #smallbusinessowner #spreadsheettips

Sheets By Olan @sheetsbyolan.bsky.social · Sep 4

Quickly translate text directly in Google Sheets without knowing the origin language! #googlesheets #googletranslate #smallbusinessowner #spreadsheettips

Sheets By Olan @sheetsbyolan.bsky.social · Sep 3

Chip & Reference HACK in Google Sheets! #googlesheets #googlesheetshack #spreadsheettips

Sheets By Olan @sheetsbyolan.bsky.social · Sep 2

Easily update the vibe of your spreadsheet with Themes in Google Sheets! #googlesheets #theme #colors #googlesheetstips

Sheets By Olan @sheetsbyolan.bsky.social · Aug 30

How to add a second deadline calendar to your Automated Task Tracker in Google Sheets! #googlesheets #tasktracker #customtemplate

Sheets By Olan @sheetsbyolan.bsky.social · Aug 29

How to add a new column to your task tracker in Google Sheets without breaking the automation! #googlesheets #tasktracker #customtemplate #productivitytips

Sheets By Olan @sheetsbyolan.bsky.social · Aug 28

How to create a new trigger in your Automated Task Tracker without breaking the automation in Google Sheets! #tasktracker #customtemplate #template #googlesheets

Sheets By Olan @sheetsbyolan.bsky.social · Aug 27

How to Rename Tabs in your Automated Task Tracker in Google Sheets without breaking the automation! #tasktracker #customtemplate #googlesheets #productivitytips

Sheets By Olan @sheetsbyolan.bsky.social · Aug 26

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

Sheets By Olan @sheetsbyolan.bsky.social · Aug 25

How to update dropdowns in your Automated Task Tracker in Google Sheets! #tasktracker #googlesheets #excel #customtemplate

Sheets By Olan @sheetsbyolan.bsky.social · Aug 24

Pivot tables are way better than biking over Cobblestone if you ask me #pivottables #googlesheets #excel

1

Sheets By Olan @sheetsbyolan.bsky.social · Aug 22

How to use the FILTER function in real life! Also not sponsored but ⁠@LePuzz is my fav puzzles!

Sheets By Olan @sheetsbyolan.bsky.social · Aug 21

COUNTIF in real life! This formula is a core to spreadsheets so it’s a must know! #countif

Sheets By Olan @sheetsbyolan.bsky.social · Aug 20

Knowing how to PROPERLY reference cells in your formulas is critical when using spreadsheets

Sheets By Olan @sheetsbyolan.bsky.social · Aug 19

How to use XLOOKUP in real life! But also that miso vermouth from hits #xlookup #googlesheets #excel

1

Sheets By Olan @sheetsbyolan.bsky.social · Aug 18

Who has RSVP’d & who hasn’t? Find out super easily with the FILTER function! #spreadsheettips

Sheets By Olan @sheetsbyolan.bsky.social · Aug 15

Easily constrain filtered ranges to avoid gettting a REF error if the list gets too long!

Sheets By Olan @sheetsbyolan.bsky.social · Aug 14

Dynamic filtering is easy to set up and even easier to use! #spreadsheet tips dsheet

Sheets By Olan @sheetsbyolan.bsky.social · Aug 13

How to create spreadsheet content! #contentcreator #googlesheets #excel