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.
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!
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |