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 |
---|---|
43 | |
27 | |
24 | |
22 | |
13 |