Creating a Google Form

In order to create a place to input data, a Google Form is required. The questions answered will automatically link with the Google Sheet, where the inputs can be organized and formatted to be shown on a Dashboard

Once inside of the blank Google Sheet, follow the instructions below to access and create the Form. For this particular instruction, the example will follow how to structure the form for tracking the max weight of a Barbell Bench PressThe exercise can be changed according to the user's intended use.
  1. On a blank Google Sheet, rename it "Exercise Tracker Data"
  2. Locate the "Create a New Form" Button under the Tools tab of your Google Sheet
  3. Change the title of the new form to "Exercise Tracker"

  4. Rename "Untitled Question" to "Date"
  5. To the right of the name, choose "Date" for the question type
  6. Add a new question and title it "Exercise Type"
  7. To the right of the name, choose "Dropdown" for the question type
  8. Replace Option 1 with Bench Press
  9. Add a new question
    1. Title the question "Sets"
    2. Choose the "Short Answer" question type
    3. Select "Data Validation" under the "More Options" tab
    4. Set the input to "Number"
    5. Set the "Number" criteria to "Is number"

  10. Duplicate the questioned titled "Sets"
    1. Title the duplicate as "Repetitions"
  11. Duplicate the questioned titled "Repetitions"
    1. Title the duplicate as "Max Weight"

Congratulations! You have now created a Google Form to track your Max Weight of an exercise. When completed, you can select Preview. The final form should look like this:Image example of a final Google Form