Spreadsheet Instructions

Hello volunteers! This blogpost is written by Alissa, one of our wonderful Volunteer Coordinators. In it, she explains how to access and navigate the sign up spreadsheet.

Instructions to access the spreadsheet

You will need to have access to Google Sheets and have a Google Gmail account. We recommend that you access Google Sheets through your browser (Chrome, Safari), either on a laptop or on a computer.

If you’re comfortable with the technology, you can also use Google Sheets on a mobile device, such as an iPhone, iPad or Android.

  • If you have an iPhone or iPad, you can download the Google Sheets app here.

  • If you have an Android device, you can download the Google Sheets app here.

Instructions to claim letter/card writing opportunities

PLEASE NOTE: Every other Sunday, an updated spreadsheet is sent out in the LAI newsletter. Please check your email and/or SPAM folder for it!

To mark which facilities you would like to write to, please follow these written instructions.

  1. Open the spreadsheet using the link found in the most recent newsletter (note, it may be in your SPAM folder).

  2. Go to Column D and find a facility that has a yellow box. The number in the box indicates how many unclaimed letters/cards still need to be written. For example, if the yellow box in Column D contains the number ‘78,’ it means that 78 letters/cards are still needed for that facility. If, on the other hand, the box in Column D is green and the number in this box is ‘0,’ it means that all letter/card writing opportunities have been claimed and you will need to find another facility.

  3. Claim a space. Once you’ve found a facility that still needs letters/cards to be written, you can claim one of the spaces. Scroll until you find a blank red box. Click on the box.

  4. Type your ID number into the red box.

  5. Hit the “Return” or “Enter” key only once. The box with your ID number should automatically turn green. If you’d like to write more than one letter/card, click on another blank red box and type your ID number again. Each box is your commitment to write one card or letter.

Alternatively, you can also watch the short below.

Help! I don't have an ID number.

Please check your spam/junk folder as sometimes LAI messages find their way there. If you are certain you have not been assigned a unique volunteer ID number, please email us at: LettersAgainstIsolation@gmail.com with “ I need an ID number” in the subject line.

Help! I want to write to a specific facility type!

If you'd like to write to a specific facility type (see image below), please check out this blogpost detailing how you can do so using the color-coded categories of the spreadsheet!

Thank you for being a part of our group! You are helping others feel “less alone.”

3,066 views1 comment
  • Twitter
  • Facebook
  • YouTube

©2020 by Letters Against Isolation. Proudly created with Wix.com