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

How to obtain sheet "created by" in Bridge for a child workflow
How can I use Bridge API Call OR Get Sheet OR another element to obtain the "Created By" metadata for use in a workflow? I see createdBy in the sheets summary in the SDK: sheetSummary - fields But I don't see it in the output of past runs of either the API Call or the Get Sheet element in Bridge. I see createdDate but not…
How and/or when does a CellLink Object 'status' get updated to 'BROKEN'?
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific tracking sheets which mirrors the task list in the in main project sheet and certain key values are linked to the main…
URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!

API & Developers

Discussion List