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
185 Views Asked by Sheri Phillips At
1
There are 1 best solutions below
Related Questions in RUNTIME-ERROR
- Java, Telegram Bot runtime problems
- Getting an error in Socket.io wordle project
- How do I fix VERR_INVALID_HANDLE (0X80004005) Error in VirtualBox?
- Unhandled Runtime Error when uploading images on next JS project. got this error Check the render method of `FileUpload`
- next js route groups issue
- Excel VBA error 1004 on PDF export - not a path issue
- I am getting "RuntimeWarning: invalid value encountered in sqrt" error in my code (RK4 method to solve Raman ODE model)
- mysql with odbc to ms access - runtime error 3146 (odbc call failed)
- I am building next js application the page works on local but when I deploy it in Vercel following error occurs
- OneDrive download link to a direct link not working, auth requested
- Error generated by MicroSoft JET database, engine could not delete from specified tables
- Excel vba sort Run-time error ‘1004’: The sort reference is not valid. Error with second of consecutive sorts with custom sort order
- stack overflow error occurs only when converting to a type with the Error method defined
- Unhandled Runtime Error in NextJS, Clerk, and MongoDB project
- Cannot find module 'node:http' in node module
Related Questions in SMARTSHEET-API
- Google App Script to add a Smartsheet summary field to a smartsheet and populate it with data from a Google sheet
- Error when enabling webhook via Smartsheets API - smartsheetHookResponse
- Sudden AttributeError: module 'boto3' has no attribute 'utils' after script has been working for a few days
- Integrate data frame from R with Smartsheet
- Script to take Row Attachments from Smartsheet with API and save to a folder in the DataBricks DBFS is not working (with no errors)
- _ssl.c:997 SSLError Smartsheet API
- Convert XLSM to XLSX in Power Automate
- Smartsheet Attachment through API - Simple CSV
- Smartsheet API Add User with Defined Locale
- Smartsheet API cURL - Attach URL to Sheet/Row
- Smartsheet MULTI_PICKLIST turning into TEXT_NUMER despite being level 2
- Writing to a multi-picklist using the smartsheet-python-SDK
- Python Smartsheet API, copying contents of one sheet to a new sheet
- Cell values not copying over to new sheet using Smartsheet API
- Creating a new sheet from another sheet's JSON
Related Questions in EXECUTIONTIMEOUT
- Reading from one tab in google sheet and writing to another sheet with some modifications.Any way to improve speed to avoid execution time out error?
- Execution timeout expired in Entity Framework but works fine in SQL Server Management Studio
- exeuction_timeout is failing the task but not sending email
- Execution timeout for program
- How to print 500+ pdf in single click with dompdf , while each pdf can have n number of pages?
- How to resolve execution timeout expired issue occuring in a stored procedure
- PHP Script stops working after 5 to 6 minutes of execution
- Asp.NET CORE: How to increase timeout of request for particular Action/ Controller
- How to set Execution Timeout in Hotchocolate 10.4.3
- ASP Classic web app times out after 2 mins no matter the setting in IIS or web.config
- ASP.Net: Enable timeout in debug mode
- Entity Framework object LINQ query Timeout issues
- Smartsheet Sync for Google Forms times out
- How to stop infinite loop in asp.net mvc
- executionTimeout to send response
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 # Hahtags
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.