Create a BMI Calculator using Google Forms and Google Sheets

Tired of those confusing weight charts and old-fashioned BMI calculators? Want a quick and easy way to see your Body Mass Index (BMI) on your phone? We got you covered!

This trick uses Google Forms and Sheets to create a super simple BMI calculator. No fancy machines or confusing numbers – just a quick form, a few taps, and there you have it – your personal BMI!

Ready to ditch the mystery and check your BMI in a fun new way? Let’s get started!

The Body Mass Index (BMI) is Someone’s weight and height ratio. This number is a rough approximation of the person’s fat percentage. Since the score is proportional to fat mass, a higher number indicates that the individual has a higher fat mass.

A person’s Underweight, Normal Weight, or Overweight status is determined by their Body Mass Index (BMI). Variables like age and geographic region determine the BMI range. 

To create a BMI calculator using Google Forms, the process is divided into three parts as follows:

• Creating a Google Form for BMI Calculation
• Link form submissions to a Google Sheet 
• Establish the BMI calculator

Step 1: Open Google on your default web browser

Turn on your default web browser and search for Google.

Step 2: Open Google Forms

From the nine dots menu bar of Google’s Home page. Select Google Forms from the list. 

Step 3: Click “Blank Form” to create a new form

On the Forms home page, select “Blank Form” to create a new form to collect the data.

Step 4: Add necessary questions and customize the form

Add the relevant questions per your requirements in the form and mark the required mandatory questions.

Note: 

• BMI calculations require a person’s height and weight. Remember that height should be measured in inches and weight in pounds (Ibs).
• Link form submissions to a Google Sheet.

Step 5: Click on the “Response tab”

Once the form has been customized, select the “Response tab” option at the top. 

Step 6: Link form Submissions to a Google Sheet

Select the “Link to Sheets” option in the right corner of the screen. 

Note:

You can select the sheet destinations for responses when you click “Link to Sheets” and choose from two options: creating a new Google Sheet or the existing spreadsheet.

Choose from two options: creating a new Google Sheet or the existing spreadsheet.

Step 7: Select an empty column for BMI calculation in the sheet

Select any blank column in the Google Sheets to calculate the BMI for each form submission. 

Step 8: Name the selected column

Give a suitable title to the selected column.

Step 9: Enter the formula in the first row

In the very first row, where the patient entries are filled, enter the BMI formula to calculate each patient’s BMI. 

In this case, Row 2 is the first line of data, G is the weight column, and H is the height column.

Type in the formula: =G2/(H2)^2*703.

Note:

• For the U.S. imperial measurement system, the formula for BMI is weight / [height]2 x 703.
• Drag the mouse’s cursor to the data rows to apply the formula to all the cells. 
• Once you have this formula, you can quickly find each new patient’s baseline body mass index (BMI) to use as a reference during your evaluations.

We use Google Sheets to make the following calculations to determine the user’s body mass index (BMI).

Age of the respondent

The user’s DOB is a mandatory field on the form. The DATEDIF function tells us the age the person is in years.

=MAP(C:C, LAMBDA(c, IF(ROW(c)=1, “Age”, 

   IF(ISDATE(c), ROUND(DATEDIF(c, TODAY(), “Y”), 0),))))

BMI Score (kg/m²)

Users are asked to input their height and weight on the form. Every response on the form has its BMI calculated using the MAP function.

=MAP(E:E,F:F, LAMBDA(ht, wt, IF(ROW(wt)=1, “BMI”, 

    IF(AND(ISNUMBER(wt),ISNUMBER(ht)), 

      ROUND(wt/(ht/100)^2,2),))))

BMI Category

We use the array function to determine the BMI category.

=ARRAYFORMULA(IF(ROW(J:J)=1, “BMI Category”, IF(ISNUMBER(J:J), 

  IF(J:J < 18.5, “Underweight”, 

  IF(J:J < 25, “Normal weight”, 

  IF(J:J < 30, “Overweight”, “Obese”))),)))

Body mass index (BMI) data is important for both people and healthcare professionals to understand in order to assess overall health, determine food needs, and set health and exercise goals. Automating the BMI calculation will free up clinicians to spend more time chatting with patients and less time doing calculations. As a result, individuals will be better able to comprehend and monitor their own health. 

While Google Forms for BMI is an excellent extension of the Google suite of products, setting it up is more work than needed.

How to create a BMI?

The height and weight of Someone can tell you their BMI. The BMI is calculated by dividing the square of height by the square of weight. If your BMI is 25.0 or more, you are overweight; if it is 18.5–24.9, you are healthy.

How to calculate BMI on Google Forms?

1. Select an empty cell if you want to put your BMI on the form you send:
2. Select.
3. Use the term BMI to identify that column.
4. Go to the BMI column and put the formula for the patient’s BMI in the first row.
5. Body mass index (BMI) = weight / [height)2 x 703 is the formula for BMI for the United States imperial measuring system.

How to create a BMI chart in Excel?

In Excel, create columns for height and weight. The next step is to put the formula =weight/(height^2) in a third column. Each person’s body mass index (BMI) will be shown in that column.