Mismatched formula

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.

0 6 226
6 REPLIES 6

Steve
Participant V

Please post a screenshot of the error screen.

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.

My formula is simply the hyperlink formula:

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

Does appsheet not recognize hyperlinks?

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

Oh, I see. Okay, thanks!

Top Labels in this Space