-
smartsheet report to Salesforce connector
Has anyone completed smartsheet report data to Salesforce using the connector addon. Any suggestion show this could be done. I know it can map a sheet in SS to SF but not sure about reports in SS to SF.
-
Automate printing labels
Is there a way to automate sending smartsheet data to another app or program to print custom Labels? Either with a button or maybe a checkbox in a "ready to print" field. Ideally this would be per row once info has been entered.
-
Populating a drop down from data in another sheet
Hello, I am in need of some assistance please! I am a developer and have been tasked with importing employee data into Smartsheet through the API. I have successfully built a C# service that pushes data into a sheet in smartsheet, my problem is they want to be able to auto populate a different secondary sheet (destination…
-
Retrieving Strikethrough Formatting with Python SDK
Hi all, I'm using the Smartsheet Python SDK to fetch data from my sheets. While the data retrieval works well, I'm encountering a limitation where cell formatting, specifically strikethrough, isn't captured. Currently, the retrieved data appears without the strikethrough even though it's displayed that way in the sheet. Is…
-
Can you help me make or identify a template for my project?
hello, I am an instructional designer at a large community college (my license is through the college). We do not have workflow or dynamic view or datac connection options licensed… no extras as far as I know. I manage some complex sheets but I have not yet mastered how to create or use templates or create a project that…
-
Power Automate
Hi We are trying to connect DYN365 to a smart sheet solution - the date has been encapsulated in a dynamic Report - but we when we try to do the power automate workflow when can't seem to link to the report - Can Power Automate connect to a report or is it only a sheet?
-
Javascript fetch vs. Smartsheet
I am trying to query a smartsheet using very vanilla Javascript, see below. I verify that cURL will work using my API key, but the code below generates 403. I cannot use "require('smartsheet');" as the website platform does not permit. How can I get my Javascript snippet to behave as well as cURL? const apiUrl =…
-
How do I loop through an Array in Bridge?
Hello! I have been trying to loop through an Array in Bridge, and can't seem to figure it out. From what I can find online, I need to use a child workflow and send the Array there while also setting the child workflow's "number of runs" equal to the length of the Array. This is partially working. The Array is being sent…
-
How to Generate List of All Smartsheet Objects I can Access?
Hello, I have records management policies and often need to get a list of all of the Workspaces, Sheets, Reports, and Dashboards I can at least view as an account member. I typically use the "Access.csv" report to do this, but it does not include a few useful things. I'm wondering if maybe there are workarounds I can…
-
Issue: Smartsheet API Not Returning Data for Formula Columns in Sheets
I am experiencing an issue with the Smartsheet API where data from columns containing formulas are not being returned when querying a sheet. However, the same data is correctly displayed in the UI and can be accessed through reports via THE API. So I can access sheet data for formula columns via a report that points to…
