Mismatched formula

AppSheet AppSheet Q&A
1

I’m not understanding what the problem is I’m getting this error:

Column ‘GDoc’ of sheet ‘Form Responses’ contains mismatched formulas. Compare the formulas displayed in R1C1 format below to see the differences. 238 rows have no formula. 3 distinct formulas are present of which the first 3 are displayed. 1 rows contain formulas like ‘HYPERLINK(“https://docs.google.com/document/d/1cvAVfF-HAoFqudp4BVb014lrbCT97YDM7o3g855bHIA/edit”)’ in A1 format and ‘HYPERLINK(“https://docs.google.com/document/d/1cvAVfF-HAoFqudp4BVb014lrbCT97YDM7o3g855bHIA/edit”)’ in R1C1 format including rows 240. 1 rows contain formulas like ‘HYPERLINK(“https://docs.google.com/document/d/1TvYyjunIoUVYF_9uqfGY2-ggBSDKHdf9pSsaDseYZqA/edit”)’ in A1 format and ‘HYPERLINK(“https://docs.google.com/document/d/1TvYyjunIoUVYF_9uqfGY2-ggBSDKHdf9pSsaDseYZqA/edit”)’ in R1C1 format including rows 241. 1 rows contain formulas like ‘HYPERLINK(“https://docs.google.com/document/d/1JaOunHHN0CWyEJcVV4BL5ny-r-SMVznFKSSglXpPT6g/edit”)’ in A1 format and ‘HYPERLINK(“https://docs.google.com/document/d/1JaOunHHN0CWyEJcVV4BL5ny-r-SMVznFKSSglXpPT6g/edit”)’ in R1C1 format including rows 242.

2

Please post a screenshot of the error screen.

3

3X_d_d_dd19fed38dd61dcc7b2d6ed594807ce72fea5d64.png
3X_d_d_dd19fed38dd61dcc7b2d6ed594807ce72fea5d64.png1190×200 44.5 KB

1 Like
4

Though not at all clear from the error, the problem is that your spreadsheet has formulas, but the formulas do not follow a pattern AppSheet can reproduce when adding new rows or updating the existing rows. You will need to remove the formulas.

5

My formula is simply the hyperlink formula:

=HYPERLINK(“https://docs.google.com/document/d/sheetID/edit","sheetID”)

Does appsheet not recognize hyperlinks?

6

It does, but that’s a formula that produces a hyperlink, not a hyperlink itself.

1 Like
7

Oh, I see. Okay, thanks!

1 Like