When you add or regenerate a table you may see the warning "Column '<column name>' of sheet '<worksheet name>' contains mismatched formulas." This article explains what this message means, how to find the mismatched formulas, and how to fix the mismatched formulas.

## Understanding Mismatched Formulas

When you add or regenerate a table, AppSheet checks the spreadsheet formulas in each column of your worksheet. If a column contains a consistent spreadsheet formula, AppSheet recognizes the formula and stores it in the "Spreadsheet formula" property of that field.

You can see the ""Spreadsheet formula" property by:

Opening your application in the AppSheet Editor.

Going to the Data > Columns tab.

Expanding the table.

Clicking on the icon to the far right of the field name to expand the field properties.

Expanding "AUTO COMPUTE"

Checking the "Spreadsheet formula" property.

When a field contains a "Spreadsheet formula", AppSheet inserts that formula in that field for every newly added row.

### Checking Spreadsheet Formulas

AppSheet checks the worksheet formula in every cell of a column. It does this by translating the worksheet formula from the customary **A1** format to **R1C1** format. **A1** format is the default worksheet formula format used by both Google Sheets and Excel. **R1C1** format is used less frequently, but it it is very useful when comparing one worksheet formula to another. It is the easiest way to determine if two worksheet formulas are exactly equivalent.

AppSheet computes the percentage of cells in the column that contain each type of **R1C1** formula. We treat an empty cell with no formula as yet another type of formula (the "Empty Formula"). Every cell in the column contributes to the percentage of one type of formula or another.

If one type of **R1C1** formula appears in a high percentage of column cells, we assign that formula to the entire column. This approach allows us to detect the formula that appears most frequently while ignoring the occasional total formula that might appear somewhere in the column.

### Mismatched Formulas

If a column contains mismatched formula, AppSheet reports the warning "Column '<column name>' of sheet '<worksheet name>' contains mismatched formulas." The warning goes on to report what mismatched formulas it has found and what rows contain each version of the mismatched formula. This can help you find the mismatched formulas. Often only one or two cells contain mismatched formulas.

You can resolve the mismatch by making the formulas in those cells consistent and regenerating the table. Every time you regenerate your table, AppSheet reexamines the formulas in each column of the table.

## Finding Mismatched Formulas

When the AppSheet Editor detects formula mismatches it displays a warning message containing:

The number of mismatches found.

The first five mismatched formulas in both

**A1**and**R1C1**format along with the row numbers containing those formulas.

Use the warning information to find the mismatched formulas.

Compare the formulas in

**R1C1**format. Matching formulas will have exactly the same formula value in**R1C1**format. Mismatched formulas will have different formula values in**R1C1**format. Even a single character difference in the**R1C1**formats will result in a mismatch.Use the row numbers to find the rows having the mismatched formulas.

## Fixing Mismatched Formulas

One common cause of mismatching formulas is using a constant row number without specifying the row number in Absolute form. For example, a mismatched formula warning will occur if the formula "$A10" appears in **A1 **format in every cell of a column. "$A" makes the column reference Absolute; however, the row number "10" is Relative because it is not preceded by a $. It will results in a different **R1C1** formula value in each row of the worksheet. If you intend to specify a constant row number, specify the **A1** formula "$A$10". In this **A1 **formula both the column and row are in Absolute form.