Link to a selected range within your Google Sheet 05:34
Link to a specific piece of text within a string of text in a cell 04:30
Different links to different pieces of text within a cell 07:22
Get a URL to a specific cell in a specific Sheet Tab and share it. 08:33
Linking can be a really handy tool for you when building your Google Sheet project. You can use it to reference a long list of external documents. Create a table of contents Google Sheet Tab for your monster of a Google Sheets project. Or even create a mini centralised information hub for your organisation or team.
Oh! Did you know that there is also a Google Sheets functions for HYPERLINKS. Why use it over the link too? Well, it is great for concurrent automation of cells down a row. Or you might want to add it to a greater formula to, say, add URL extensions automatically.
Google Apps Script: WebApp, HtmlService, LockService; Google Sheets
In this tutorial, we are going to create an interactive story chain app that we can embed into a Google Site or your own site like WordPress.
What’s a chain story, Yagi?
Maybe you did this in school. Someone wrote the first part of a story. You then gave that story to someone else to continue writing. They then pass the story onto someone else to write the next part. And so on and so forth. In the end, the story is read out and everyone laughs at the direction the story went – except that one kid silently raging of their lack of control of the narrative.
Why are we making this? How’s it going to help me?
Well, for one, I thought it would be fun. More importantly, this will allow us to have a look at how Google Apps Scripts communicates client to server-side and vice versa in a little more advanced environment than our previous tutorial. It will also give us an opportunity to look at some more parts of Google Apps Script as they relate to creating a WebApp.
Our chain story WebApp tutorial will also give us an opportunity to look at some of the pitfalls of using WebaApp. Particularly when using the execute as me permissions. Finally, this will then launch us into our follow up tutorial on updating the WebApp to execute as the user rather than me, the owner of the app.
This tutorial is the second part of the WebApp series. However, if you can read a bit of JS, CSS and HTML, you should be able to follow along and if you get stuck you can always go back to the first tutorial:
One of the beauties of Google Sheets is collaboration. In this tutorial, we will cover how to insert comments in Google Sheets so that you can target cells and ranges for discussion with comments. In this tutorial, I’ll cover,
Seeing how many comments there are in a Google Sheets tab. 11:20
There is a lot to comments. Mostly learning comments is quite intuitive, however, it is important that your users know what they need to in order to be able to effectively communicate with each other in the Google Sheet.
Find out how to add alternating colours in your rows in Google Sheets. Adding alternating colours in your spreadsheets can really help your viewers to reference data accurately while also allow your spreadsheet to look quite smart and professional.
Google Sheets has a quick and easy alternating colours tool to help you to fancy up your spreadsheets in seconds.