I'm getting an error for a survey that has about 90 questions but only 10 respondents when I try to use the Smartsheet Sync add on. Error says that it"Exceeds Maximum Execution Time". How can I increase the execution time so that it will add responses to my Smartsheet? I don't know anything about coding. I'm not evens sure if I could edit the add-on? Please advise.
Smartsheet Sync for Google Forms times out
182 Views Asked by Sheri Phillips At
1
There are 1 best solutions below
Related Questions in RUNTIME-ERROR
- Error 404 not going after Wordpress Permalink change to custom structure
- Runtime error when using N-1 in limit clause of select query when N=0
- How to determine data point that gives error?
- Nginx + php5-fpm not displaying php errors but cli is showing errors
- What is the difference between Swift 2.0 do-try-catch and regular Java/C#/C++ exceptions
- Matlab error in file path for a sound
- Windows application using libusb: runtime error due to mutex lock
- Accessing data stored in .CSV file
- Runtime Error [Android Studio] Linphone Project
- What causes a runtime error in this code
- "No suitable driver found" error when trying to connect with UCanAccess
- Runtime Error on UVA judge and Wrong Answer on codechef on the samequestion
- VBA Run-time Error 7 Out of Memory
- RuntimeError: maximum recursion depth exceeded [py2exe]
- ArrayIndexOutOfBoundsException in Grid with Allow Selection (Genexus)
Related Questions in SMARTSHEET-API
- Smartsheet data into Gridview
- Creating reminders and alerts with Smartsheet API
- Adding an EOL characters to string sent to Smartsheet via Update Row(s) API call
- Failed uninstall/install of Smartsheet Python SDK
- Copy a folder with Smartsheet API - Java SDK 2.0.5
- Smartsheet API Python - extract data from external excel file by cell and update into a smartsheet using API
- How to parse Smartsheet API 2.0 Python SDK error results?
- Updating cells in smartsheet (java)
- How to store file on Bucket s3 with specific tree and then Zip it
- Smartsheet-api, Is there any way to get manually deleted row using smartsheet api or sdk call
- Is there any way to get deleted row data from smartsheet using webhooks
- The suitable way to import data to CRM ( Smartsheet) from website?
- Retrieve row data from smartsheet in C#
- Creating excel sheet and entering into SQL won't work when run together?
- Connect Excel to Smartsheet via Power Query
Related Questions in EXECUTIONTIMEOUT
- Different execution time for same query - SQL Server
- How to correctly fix phpMailer max execution time error?
- how documentum method timeout performed?
- PHP Script stops working after 5 to 6 minutes of execution
- Asp.NET CORE: How to increase timeout of request for particular Action/ Controller
- ASP Classic web app times out after 2 mins no matter the setting in IIS or web.config
- How to set Execution Timeout in Hotchocolate 10.4.3
- Execution timeout expired in Entity Framework but works fine in SQL Server Management Studio
- Smartsheet Sync for Google Forms times out
- Httpruntime- ExecutionTimeOut
- How to resolve execution timeout expired issue occuring in a stored procedure
- Configuring httpRuntime execution timeout for large downloads
- ASP.Net httpruntime executionTimeout not working (and yes debug=false)
- In PHP does max_execution_time affect shutdown functions that are run through a register_shutdown_function() call?
- How to increase MiniTest timeout threshold?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Thanks for sharing your form with me, so that I could take a closer look. It appears that your form actually contains 96 sections each with multiple questions. When you create a Google Sheet for the form responses, 361 columns are created.
This is probably the cause of your issue. Each sheet in Smartsheet can only handle around 200 columns per sheet, and Smartsheet Sync automatically tries to create a column for each question in your Google Form. It appears you have uncovered a bug where our error messaging in Smartsheet Sync could be better - informing the user that the form has more questions than a sheet can handle, rather than trying to create the sheet and then timing out. We will make a note of this bug so that we can address it in a future revision.
As it stands, Smartsheet would not be able to handle a form with 361 questions, so it doesn't appear that Smartsheet Sync will be able to handle this form.