API & Developers

Archives for September 2020

Can a URL be clickable on the Approval process?
We are using an approval workflow to have one person add a URL to a form and that triggers the approval email. From there, someone needs to click on that URL to ensure accuracy and then approve if correct. When the recipient receives the email, they click View Request in the email and on the popup, it displays the link…
How do I add a link in a Smartsheet form?
I need to add a link in a Smartsheet form. So far I see that I can add a link to a header. but i need it to be conditional on a prior field. For example, if you answer YES, then a field appears with a link to click on.
Sync with Google Form is stuck
I am trying to sync a google form with Smartsheet. I installed the Add-On with no issues. From my Google Form I click Add-Ons --> Smartsheet for Google Forms --> Start --> Start & it spins incessantly until it eventually gives a time-out error. What am I missing here? I really want this to work!! Julie Williams
Can Hyperlinks be added automatically
Is there a way to add hyperlinks to data automatically when it's entered into a sheet via a form based on certain criteria? For instance, when a list of customer numbers has a new row added via form, can the sheet add a hyperlink to that customer number that will take you to a detail dashboard for that customer? If not by…
Need a solution for tracking employees in the office
Hello, I have been tasked with creating a "calendar" in which our employees can sign up to be physically in the office so we can monitor numbers. Right now we can only have 25% of our employees in the office at any one time. I can do this in SharePoint but we are currently using on-prem so people need to be connected to…
Card Order Data via API Response
I am trying to identify the order of cards in card view based on the JSON response to a GET request to the API for a sheet. I created a schedule type sheet as a test project. When I change the order of cards (by manually dragging them up and down in card view), there appears to not be any change to the response JSON that…

Trending in API & Developers

What is the proper Content-Type string for an Excel (xlsx) file row attachment?
Hello, I have an Excel document (xlsx) that I want to upload to a row through the API. My code does successfully upload the file as a row attachment. However, when I download the file through Smartsheet and try to open it, I get an error "Excel cannot open the file 'file_name.xlsx' because the file format or file extension…
Smartsheet Bridge special characters not encoding in endpoint URL
Has anyone ran into this issue? I would like to parse an ISO formatted time into the endpoint URL, but it's not encoding "+" to %2B. My particular use case is getting the latest CVEs from Vulnerability APIs (nist.gov) The endpoint should be formatted as such:…
3rd party addons for Smartsheet
Does anyone have a list of available free and/or paid 3rd party addons for Smartsheet? Simple tools that solve specific problems, like ddupdate, can be invaluable. Having a repository or a guide where to look would be really appreciated. Thx!

API & Developers

Discussion List