FamilySearch Wiki:WikiProject Creating the Czech Archive Finder, Part 1

Project Leader
Heather Mecham

Task List
Task List

Purpose
Adding FamilySearch Collections to the Czech Gazetteer Google sheet.

Project Instructions
This project only needs to be completed in Google sheets. 1. Go to the Task List. 2. Select a letter in the tab column to work on in the Czech Gazetteer Google sheet by putting your name in the name column. 3. Go to the Czech Gazetteer Google sheet and find the letter you selected, which will be across the bottom of the Google sheet. 4. Sort the sheet by the archive column (column E) by following the steps below.
 * a. Select the entire sheet by clicking the empty rectangle to the upper left of the sheet.
 * b. Go to the data menu and click "sort range".
 * c. Check "data has header row" box.
 * d. Select the column header "archive" which is column E.
 * e. Click sort.

5. Use the key in the table below to determine which code to add to each line.

6. Copy and paste the code from the table below into one line of the Google sheet. Then highlight the code you just pasted and copy it from the Google sheet. 7. Highlight all of the cells where you want to place the code and paste the code. If it says blank, leave that cell blank.