-
Sheet Access Report via API
As we are automating our process to manage users and sheets we are looking for a way to automate pulling the data that is contained in the Sheet Access Report. As an admin using the admin token, I am able to pull a list of sheets and then able to use the API to gather some information on the sheets but am unable to gather…
-
How to enable Google Maps - "Distance Matrix API" on Smartsheet?
Hi - I don't want to spend money on the vendor/partner that Smartsheet are using for mapping. Does anyone have a working setup they can share which leverages the Google Maps "Distance Matrix API" ? Similar to this article -…
-
Customer add/edit sheet rows
I need customers to be able to add rows of information to a smart sheet, and later be able to edit those rows. A scrolling table view interface would work better than a form so users can see multiple records at a time. The sheet needs to be secure so that customers can only see/edit their information, and not be able to…
-
Workday.com & Smartsheet Connection for moving data
Any thoughts on what the best path forward be to build a connection between workday.com and smartsheet? Currently stuck evaluating between using Bridge or Smartsheet API/Workday API. We would like to be able to select specific line detail to be sent to workday for the req to check process and bring the requisition number,…
-
Move rows Automatically | Automation Workflows
Hi, I have 1 source sheet and 1 target sheet. Using Data Mesh/ Shuttle, I'm adding the records to the target sheet from the source. There are chance that few records in the source can be deleted later and such records are not to be retained in the target as well. So, I added a column formula in the target that checks if…
-
Leading zeros dropped on Python SDK add_rows
We are using the smartsheet-python-sdk to insert rows into SmartSheets. For almost two years we have had this script running with no issue, but in the last week, SmartSheets has started to trim the leading zeros on fields that are all numeric. Nothing has changed in our sheet or in our script. Are others having this issue?…
-
Why is permalink not included in response?
I'm hitting the Smartsheet API with: METHOD: POST URL: https://api.smartsheet.com/2.0/sheets/12345/rows?include=rowPermalink REQUEST BODY: [ { "cells": [ { "columnId": 11111, "value": "Random Text" }, { "columnId": 22222, "value": 1 } ] } ] I get back a success response that includes an array of row objects. The…
-
Automated Backups - SharePoint
Hello team, I have scheduled weekly backup in Smartsheet and I was wondering if it is possible to have the backup file automatically moved to a SharePoint folder. At the moment I need to download the file every week and and upload it to SharePoint. I am hopping that there is a way to automate this process. Thank You.
-
Workday Financial Integration
An integration between Smartsheet and Workday Financials could significantly streamline project and organizational financial management. Such a connection would enable real-time financial updates, enhancing transparency and decision-making agility. It would also reduce manual data transfer errors, increase efficiency, and…
-
how to delete all the rows of a sheet using python at once
I am trying to build an automation that updates an excel file to smartsheet once I run it. I have build that program but issue i am facing is that they are getting updated below the previous one. So I want to delete the rows first .Is there any way to do it without requiring row id.?
