Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.

GOOGLE FORM - ERROR

Nathaniel Pall
Nathaniel Pall ✭
edited 12/09/19 inArchived 2015 Posts

I had my Google form synced with Smartsheet and it has been working well. For no known reason, new form entries from Google no longer enter into Smartsheet. An error occurs when I go into the Google form and try to reconnect.

The error is below:

What could have caused this error?

How can I fix this error without having to create a new form and sheet?

GOOGLE_ERROR.png

Tags:
· Share on Facebook Share on Twitter

Comments

  • Travis
    Travis Employee
    edited 05/14/15

    Hi Nathaniel - there is a known issue that is being investigated by our team. In the meantime, to fix this, try disconnecting the add on, then reconnect it to your account. Once you have set up the sync again, it will create a new sheet, but you can use the Move Row feature to move the rows from your old sheet to the new sheet.

    · Share on Facebook Share on Twitter
  • Kate Ervin
    Kate Ervin ✭✭

    Wow, I just did as Travis suggested because my form was still collecting new data, but the smartsheet stopped showing that data for no reason. So I unlinked the smartsheet entirely, and then started the add-on again for that form. Seems to work for now. BUT, the Move Row feature moved the rows and deleted a bunch of the data in those rows (i.e. the rows that showed up in the new sheet were incomplete). Glad I have the Google Spreadsheet as a back-up!

    · Share on Facebook Share on Twitter
  • Travis
    Travis Employee
    edited 01/25/16

    Hi Kate, if the destination sheet does not have the same columns (type and name) as the source sheet, new columns will be added at the far right of the sheet, with the data from the source sheet.

    Moving rows will not delete data - try scrolling to the far right of your destination sheet on the rows that you moved.

    Let me know if you are still unable to locate the data!

    · Share on Facebook Share on Twitter
  • Kate Ervin
    Kate Ervin ✭✭

    I did find the data to the far right, thank you. Unfortunately, the conditional formatting and formulas that I had added were not preserved.

    We would like to keep our Google Form synced with the Smartsheet, while also adding some new columns into the Smartsheet (in between some of the form columns). Is this dangerous?

    What about renaming the column headers? I noticed they're a truncated version of the column headers for the Google spreadsheet containing the Google Form responses.

    Kate

    · Share on Facebook Share on Twitter
  • Travis
    Travis Employee

    Kate - renaming columns and adding additional columns to your sheet will not affect the sync. The integration is pointing to specific column IDs, not column names or location in your sheet.

    Hope this helps!

    · Share on Facebook Share on Twitter
This discussion has been closed.

Categories

I understand. Unfortunately, there is no other option that I see. One thing to make it easier for you to add the name is to have a helper column in the source sheet with a formula to identify duplicates. If there is a record with no duplicate (i.e., a new name added), you can get notified through a workflow and use that to add the name to your metric sheet.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106984,"type":"question","name":"Using Countif to count Often and Very Often,","excerpt":"however I can't get it to work the Often is also counting the Very Often: =COUNTIF([Tools & Resources (SE-2)]8:[Tools & Resources (SE-2)]12, HAS(\"Often\", @cell), NOT(HAS(\"Very\", @cell)))","snippet":"however I can't get it to work the Often is also counting the Very Often: =COUNTIF([Tools & Resources (SE-2)]8:[Tools & Resources (SE-2)]12, HAS(\"Often\", @cell), NOT(HAS(\"Very\",…","categoryID":322,"dateInserted":"2023-06-27T22:21:22+00:00","dateUpdated":"2023-06-27T22:25:38+00:00","dateLastComment":"2023-06-27T22:37:19+00:00","insertUserID":13941,"insertUser":{"userID":13941,"name":"steinkj","title":"","url":"https:\/\/community.smartsheet.com\/profile\/steinkj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-04\/84\/c0\/n84c060f2d4e16db2de757af80ad4cdca.png","dateLastActive":"2023-06-27T22:35:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":13941,"lastUserID":13941,"lastUser":{"userID":13941,"name":"steinkj","title":"","url":"https:\/\/community.smartsheet.com\/profile\/steinkj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-04\/84\/c0\/n84c060f2d4e16db2de757af80ad4cdca.png","dateLastActive":"2023-06-27T22:35:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3375811121,"url":"https:\/\/community.smartsheet.com\/discussion\/106984\/using-countif-to-count-often-and-very-often","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106984\/using-countif-to-count-often-and-very-often","format":"Rich","lastPost":{"discussionID":106984,"commentID":382723,"name":"Re: Using Countif to count Often and Very Often,","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382723#Comment_382723","dateInserted":"2023-06-27T22:37:19+00:00","insertUserID":13941,"insertUser":{"userID":13941,"name":"steinkj","title":"","url":"https:\/\/community.smartsheet.com\/profile\/steinkj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-04\/84\/c0\/n84c060f2d4e16db2de757af80ad4cdca.png","dateLastActive":"2023-06-27T22:35:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-28T09:04:26+00:00","dateAnswered":"2023-06-27T22:35:14+00:00","acceptedAnswers":[{"commentID":382720,"body":"

Hi @steinkj<\/a>, change the \"HAS\" to an equal.<\/p>


<\/p>

=COUNTIF([Tools & Resources (SE-2)]8:[Tools & Resources (SE-2)]12, \"Often\")<\/p>"},{"commentID":382723,"body":"

Thank you, as always I was trying to make it too hard!!!!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106939,"type":"question","name":"How to extract part of a cell and remove the rest","excerpt":"Hello I have a very long column with various texts in every cell containing for example 'Data change request from John Smith', every cell contains different types of requests and I want to extract to another column only the text before the word 'request '. Could you please help me how to do this? Thank you so much!","snippet":"Hello I have a very long column with various texts in every cell containing for example 'Data change request from John Smith', every cell contains different types of requests and…","categoryID":322,"dateInserted":"2023-06-27T09:11:14+00:00","dateUpdated":null,"dateLastComment":"2023-06-28T09:51:15+00:00","insertUserID":143328,"insertUser":{"userID":143328,"name":"Christiana Gkini","url":"https:\/\/community.smartsheet.com\/profile\/Christiana%20Gkini","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtf-hNm8WhOgG9NXB7Zou6oQaUyDHZZ2iwrHmrrz=s96-c","dateLastActive":"2023-06-28T10:00:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":151203,"lastUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T11:57:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":27,"score":null,"hot":3375804749,"url":"https:\/\/community.smartsheet.com\/discussion\/106939\/how-to-extract-part-of-a-cell-and-remove-the-rest","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106939\/how-to-extract-part-of-a-cell-and-remove-the-rest","format":"Rich","lastPost":{"discussionID":106939,"commentID":382775,"name":"Re: How to extract part of a cell and remove the rest","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382775#Comment_382775","dateInserted":"2023-06-28T09:51:15+00:00","insertUserID":151203,"insertUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T11:57:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-28T09:27:10+00:00","dateAnswered":"2023-06-27T11:27:01+00:00","acceptedAnswers":[{"commentID":382494,"body":"

Hi @Christiana Gkini<\/a>,<\/p>

If the format of the entries is consistent then you can use a formula similar to this:<\/p>

=LEFT([Column to check]@row, (FIND(\"request\", [Column to check]@row) - 2))<\/p>

Example:<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

Obviously you will probably need to change the \"Column to check\" in the formula, but this should be straightforward enough.<\/p>

Hope this helps; any questions or issues then just post! 😊<\/span><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • Orderable Charts

    Good morning, I've done several searches here but now I'm going in circles. I have a sheet with records of usage of certain scripts we have. Each row has the user name, the script they used and the time they saved by using each script. My goal is to create a dashboard with two bar charts: user name vs total time savings…

  • 经常使用条件统计计数Very Often,

    however I can't get it to work the Often is also counting the Very Often: =COUNTIF([Tools & Resources (SE-2)]8:[Tools & Resources (SE-2)]12, HAS("Often", @cell), NOT(HAS("Very", @cell)))

  • How to extract part of a cell and remove the rest

    Hello I have a very long column with various texts in every cell containing for example 'Data change request from John Smith', every cell contains different types of requests and I want to extract to another column only the text before the word 'request '. Could you please help me how to do this? Thank you so much!