Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hi, i have enabled Google forms sync for Smartsheets, when I click the add-on for smart sheets in a form and it tries to connect to SS, I get this error:
Smartsheet Sync:
Has been denied access to your data.
any help on what is going on here?
Hello,
It's possible that during the authentication process, the Deny button was clicked instead of the Allow button, which enables the add-on to work.
Try removing the add-on and then adding it back again. To remove it, go to the Google form and select Add-Ons > Manage Add-Ons > Manage (next to the Smartsheet add-on) > Remove
Then download it again from the google add-on store and see if you can authenticate.
If that doesn't work, please reach out to our Support team to troubleshoot further.
I have just tried to do the above. I try to sync and I get the access denied. I have removed the add-on, shut down the browser and repeated the whole process again - being careful to ensure I don't hit deny, but I still cant sync.
Hi, We are a developer and building a custom web platform for one of our client who is using smartsheet. Our platform needs to get data from smartsheet and need to show the data in our custom UI. Could anyone recommend the APIs we should be using for this?
This solution updates a column formula across multiple sheets in a workspace. The script finds all sheets with a certain string in the name, finds a certain column by name on those sheets, and then updates all column formulas to a new column formula. At the time of posting, Control Center Global Updates did not allow me to…
We have a webhook created in one of our Smartsheets, and we've been noticing lately that the webhook callbacks immediately disables the webhook after 1 try, causing data discrepancies between the Smartsheet and the system it sends the data to. Here's an excerpt JSON message received from Smartsheet showing the callback…
