Hi, I did this a long time ago and put notes on how I did it in OneNote. I just tried to do it in another WorkApps the same way and it gives me an error. I am trying to embed a tableau dashboard into …
Hello, I am having trouble updating the value of a multi-picklist in my sheet. I am using the Java SDK smartsheet-sdk-java 3.1.1, on Java 17. I am setting the column value with the following code: Cel…
Hello! Perhaps I'm being dense, but how do you get page 2 results from the API using this endpoint using CURL: https://api.smartsheet.com/2.0/reports I can see that there are 3 pages from the response…
Hey guys, I am helping a client elevate their Smartsheet setup. Currently, they have an email automation that sends an email to a customer when a certain field in smartsheet has been updated. The emai…
I'm trying pull data from either s csv or google sheet. Can anyone explain to me what is wrong with my script below? No matter how hard I try I get the error: "Unable to parse request. The following e…
We have a file of data in Excel with Macros to another system with confidential data. We want to send rows and update rows to a Sheet in Smartsheet. Has anyone used Power Automate or another tool to d…
It seems like the history log would be the best place to pull this information, but I am not seeing a way to pull the history log via API. Pulling the info cell by cell seems cumbersome. Can someone p…
I'm using power automate to wire up some info into smartsheets. I have everything working so far but multi contact list and multi pick list. The contact list error I get is this: The value "John smith…
trying to include the rowpermalink in my sheet export according to the API doc the ?include=rowpermalink in the URL should do it however it does not show in the row with all the other data from the sh…
Our IT is getting automated reports with our API Key from Smartsheet and has sent me the following email / question: The end of line character in the file is also a line feed (LF), instead of line fee…
Hi there, I'm trying to format a single cell in the first row of a sheet using the python sdk. I'm finding that all subsequent cells in that column show the same color despite no format being applied …
I am running into an error when connecting Smartsheet to Power BI (Power Query). I am trying to refresh my PBIX file, but I run into the following error when trying to connect my Smartsheets: The issu…
Hello all, I am relatively familiar with Smartsheet and VBA. From my understanding I will need to API access to achieve this, but am I able to write a VBA script that pulls my excel file into a Smarts…