API & Developers

Archives for February 2018

Google Forms sync - access denied
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?
Integrating with SharePoint
I would like some suggestions for integration with SharePoint. What are the best practices and ways to share information. Will information shared be actively updated or is it best to generate reports to be shared as static images that update at certain intervals? All suggestions would be much appreciated.
HYPERLINK API
We have been using HYPERLINK("http://website.ws/links", "Click Here") in both excel and google spreadsheet, and since we need jotforms integration for client our current links in smartsheet is very long and creating hyperlink manually for each row is a terrible ordeal. It would be great if you add HYPERLINK("URL", "Text")…
Fillable PDF
Has anyone tried to use the submit button on a fillable PDF form to send data into smartsheet? Doens't seem to difficult but could use some guidance.
API 2.0 formula
Has anyone had any experience of trying to add a formula through the 2.0 API? If so could you please let me know what the JSON syntax should be?
Rate Limit Error
Last week encountered for the first time a rate limit exceed error (4003) in our nightly batch-process. This batch proces is synchronising Smartsheet objects with our TimeTracking application 4TT. Since 2016 this proces works fine, but somehow now this rate limit error occurs and therefore stops synchronising. With the…
Moving Task - Multiple Selection
Hello, I am wondering if smartsheet can allow a user to move a few tasks all at once to a different due date, or status. Instead of changing each one, one at a time? Thanks!

Trending in API & Developers

COUNTIFS and OR
Hello, I am having trouble getting my COUNTIFS formula containing an OR to work. I need it to count based on range 1 and a second column containing either Planned or Submitted. =COUNTIFS({RegSci Review Projections Range 1}, [Primary Column]@row, OR({RegSci Review Projections Range 2} = "Planned", {RegSci Review Projections…
When a new row is created in Smartsheet, Create SharePoint List Item
I'm trying to do my first Smartsheet Power Automate flow. I've created a SharePoint list to hold the data. When a new row is added to a Smartsheet, I would like for that row of data to be used to create a new item in a SharePoint List. The part that I need help with is the mapping of the columns from the SharePoint Create…
Smartsheet API Call
Hello Team, Please let me know the best way to make an API call from Smartsheet to request data from another tool and how to handle the response. I know I need to use a GET request to make the API, call but I am not sure how to handle the response in Smartsheet. Many Thanks,

API & Developers

Discussion List