A couple useful tools to consider when using Google Sheets.
Currently just a few contact related ones, but more to come!
itty.bitty.site - for downloading data
itty.bitty.site is able to render any data for downloading. All you need to do is provide the right mime-type and content.
I use this for contact cards, but it can probably be used to make calendars and much much more.
Downloading Contact Cards
You can create a calculation that generates a vCard content payload:
And then use itty.bitty to download it.
This tells itty bitty to treat it as a vcard file, and supplies the content that goes with it.
In the above example A3, B3 are the name, and other fields provide telephone and email.
Downloading Calendar Data
Note on privacy
Both itty.bitty.site and redirect.app do all their work in your web browser. The server that hosts them does not have access to any of the data that is sent.
Using dynamic column lookup
Main Formula (Placed in cell A2)
Select the pink cell and copy the formula. - Paste it into Cell A2 in a new sheet.
Create a named range called “DATA_RANGE" and point it at your data (or replace that with the name of the sheet)
Select the first row and choose Data Validation, then select the first row of your Data Range area