-
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 add a row with a CONTACT_LIST column using API (python)
I am trying to add a row to an existing sheet with a CONTACT_LIST column. As far as I can tell, I am following the syntax properly, but I am always getting a validation error in the response. Can someone provide a sample request for this operation, using python. I found this similar question, and it says it was answered,…
-
Login to my app via smartsheet sso
I create a application with GUI to handle with data from smartsheet (crud). Then I make login module via OAuth2 flow to get the token to authentication and call some smartsheet API. But when I am done these procedures, I got a access token and refresh token which is not in jwt token. I use that token to call smartsheet API…
-
SAML Authentication issue when changing from PingFederate to PingONE
Encountering the following problem: "The EntityID associated with this IDP is already in use. Please select a unique EntityID for your setup." Even though we're using a different IDP, the problem persists.
-
changing the Row number for coommets?
Hello, Is there a way to change the comments notification to show a Ticket ID number instead of the row number? So in the picture change the Row 441 to ticket ID 500?
-
While posting data in smartsheet from servicenow i get this below error
I am using the below payload to insert rows var row = [ { "toTop": true, "cells": [ { "columnId": 8555792218515332, "value": "123" }, { "columnId": 393017893906308, "value": "123", "strict": false }, { "columnId": 4896617521276804, "value": "123", "strict": false }, { "columnId": 2644817707591556, "value": "555", "strict":…