-
Internal ERP - Connect to Bridge or Smartsheet API?
I’m struggling to understand the value of Bridge vs Smartsheet API when I need to connect to an internal ERP system. We are looking to display a list of sales orders (from ERP) per each project (in SS). We have thousands of sales orders that are updated constantly and we’d like to see that data near real time Would this be…
-
Maps & Hyperlinks
I know that the smartsheet charts app is still in production, but is it possible to have sheet containing North American states and hyperlinks, then using the 'map' chart, click on a particular state and then it will take you to that hyperlink?
-
Is there a way to attach an URL to a proof?
Hello, I am able to create a proof with a link instead of file from UI. But I cannot see such functionality in API. I tried to do a POST request to /sheets/{sheetId}/proofs/{proofId}/attachments with the same JSON body like for adding URL to a row but with no luck - "errorCode" : 1011, "message" : "A required header was…
-
Commenter access level in API
Hello, I have shared a sheet with a user using Commenter access level. But when I request for shares with API I get VIEWER access level in response. How can I get a real value for Commenter access level? Also is it possible to set Commenter access level with API? Thanks, Michael
-
Smart Sheet API GET Rows not wokring
Hi all, I am using the smart sheet api to read and update a rows values. I am performing this task using a python script and then requests library. My current code setup looks something like this ------------------------------------ import requests Test = "_________________________________________" url =…
-
How to publish tableau dashboard connected to smartsheet to a tableau servert
Hi, I am able to connect my smarsheet data to tableau desktop app via API token. However, when I publish my workbook on my server, it prompts me to sign in with a user name and password. I am an SSO user on smartsheet therefore don't have a password. Can anyone please advise how do I get around this please? Maz
-
Populating a Dropdown List
Hi, is it possible to populate the contents of a dropdown list from another smartsheet?
-
Using smartsheet-python-sdk to put data back into Smartsheet
I used the smartsheet-python-sdk (and unique API key from Smartsheet) to automatically pull data from Smartsheet into my Python script along with other data sources to create new feature-engineered columns. Is there an automatic way to now put these new columns I created back into the same Smartsheet I initially pulled…
-
Adding one word in front of selections in multi-select dropdown column
Anyone know of a formula that would do what I've manually done in the screenshot below? I'm trying to add one word in front of each multi-select option selected and put into a new column.
-
How to get template Id sheet has been created from?
Hello, Is there a way to get template that was used for creating a sheet using API? What does "source" property of a sheet means? Thanks
