-
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.?
-
Resource Management API - Nag email
One huge feature that's missing from Resource Management is a simple email notification that you have unconfirmed time. I'd like to automate this since it's not included. But a couple things that are confusing: The APIs for Resource Management are posted, but can you access these APIs from the Smartsheets Python SDK? I…
-
Has anybody successfully converted their HTTP Call (deprecated) to a Make API Call?
I have been converting a working HTTP Call function (soon to be deprecated) to a Make API Call, and creating API profiles. I'm getting a Plugin Error as attached. I have all my headers in my API Profiles with non-empty string names and I still get this error. Please advise!
-
Business proposal
I am currently scrutinizing a received business proposal for the establishment of my online travel agency. My objective is to ensure the success of the business by strategically leveraging robust programming languages, frameworks, and technology stacks that seamlessly integrate. This includes meticulous adherence to laws,…
-
Unlocking columns on sheets with dependencies enabled via the API
When trying to unlock columns via the API on sheets where dependencies are enabled, you get an error due to these dependencies, stating that these need to be disabled first. Unfortunately, there is no method to do so programatically. The API should either provide functionality to still unlock columns regardless of…
