-
Bridge: Add Row module with empty cells
Hello - I am working a Bridge workflow to Get Row from a source sheet, and Copy Row with select columns to a target sheet. The workflow between the sheets is working great, but my question is that some row cell information will be blank from the source sheet going to the target sheet and thus my Get Row Cells Values come…
-
Bridge Salesforce API - SF Contact Module
We're looking to pass contact information associated with Salesforce opportunity records into Smartsheet. We have the Smartsheet / Salesforce Connector in place, but following the current structure would explode the number of fields necessary to denote all possible roles associated with each project. Is it possible to…
-
API PUT and Body help for Cell link from a cell in sheet "a" to sheet "b"
I am having trouble linking a cell from sheet a to b. I am new to using API and possibly just getting the call wrong? or the body. Any help would be appreciated. PUT: https://api.smartsheet.com/2.0/sheets/4098048888098692/rows/1370574824361860/cells/259016080 Body: { "cells": [ { "linkinFromCell": {…
-
API Access Tokens for non-licensed Users
I've seen varying information about who can generate an API Token. For example, I am a "free" unlicensed user who has access to a licensed user's sheets. That licensed user is part of the Enterprise plan. I am setup as a "Viewer". When I try to generate a token, I get a message saying I need to Upgrade my plan. Can anyone…
-
How to get access token in Smartsheet
I have a my service account with email id , using that I have to get access token from Smartsheet to do more calls Is there any API for that ?
-
How to make a POST call using webhook
I have a use case where I want to trigger a UiPath Automation if any row gets added to a smartsheet. I went through the webhook documentation but in the create webhook function, we can pass just a URL for the "callbackurl" key. Since I have to make a POST call, I have a list of input paramters in the request body (plus the…
-
Technical Support Horrible
We are new to Smartsheet and we are on an Enterprise plan. I had three interactions with support so far and all three have been horrible. First one was regarding this: Populating Contact List Dropdown — Smartsheet Community. I got more information from the community than the actual support case I opened online. The…
-
Connecting to Amazon QuickSight
Hello, we currently utilize amazon QuickSight to build automated dashboards from other websites. Would it be possible to connect the data collected on Smartsheet to build automated dashboards on QuickSight?
-
Creating and Formatting Sheet Summary Field with API using Python
I am updating a handful of sheet summaries using Python. My current code creates the sheet summary fields that I want with the correct formulas however I am unable to get the formatting to work properly. Below is a partial screenshot of the code: According to the API docs I should be able to set the formatting of the sheet…
-
Smartsheet Revenue & SAP
Hello Smartsheet Community, We are using Smartsheet to forecast revenue. We export recognized revenue monthly and import into SAP for offical reporting. We'd ideally like to be able to set up a connector to eliminate the manual intermediate steps. Is anyone doing something similar in their solution who would be willing to…
