-
Seeking consultants
We're an organisation responsible for government facilities management, asset management and projects . We currently use Smartsheets but require refined and custom built business solutions to assist in business operations. We're seeking expressions of interest for Smartsheets consultancy services and ongoing support.
-
Populating Smartsheet Containing Approval Workflows with Multiple Excel Reports
Hi, I am looking to use Smartsheet for an intake request that would then get pulled into Alteryx to produce a report (this part I have down using the Live Data Connector). Next, I need to write that report that is created using Alteryx back into Smartsheet so I can have a workflow for approvals. Each time a report is ran…
-
How to code Python in Zapier without using Smartsheet python SDK
Using Smartsheet Python SDK, I'm running the following code to access Smartsheet to: Get customer list from "Customer name" column of a Customer sheet Update Picklist of "Customer name" column with the customer list get from 1. import smartsheet # Initialize Smartsheet client smartsheet_client = smartsheet.Smartsheet(my…
-
Can Create Update Request api call include all columns without explicitly specifying the column id's
Hi, The Create Update Request takes columnIds (array) as input. Is there any hack to tell the api that all the columns in the sheet need to be included in the update request without having to explicitly provide all the column id's as input in the api call. Thanks. cheers, senthil
-
How do I add linkInFromCell by REST API?
using Python SDK. If I use add_row it will tell me that this is not allowed. If I use update_row, and with a random value (if value != null), it will return the following error. "errorCode": 1110, "message": "cell.value must be null if cell.linkInFromCell is non-null." If I use update_row, and with a value:null it will…
-
Reduce the amount of info in the webhook notification
Hi, Lets say you have a sheet with lots of formula columns and lots of rows. The webhook notification seems to include all the rows in the sheets and all the cells in all the formula columns for all the rows. This happens even if you just changed one cell in one row and saved the sheet. Is there a way to do any of the…
-
ENHANCEMENT REQUEST!!
I created a scheduling system using a grid/form/dashboard. After implementation I found out that forms do not have any permission settings. Ex. I had a grid/form that I only want 10 people to access, the grid is restricted but everyone can access and submit using the form. For this project to be successful, I either need…
-
Smartsheet and QuickBooks Integration - "Amount is not equal" Error
Hi, I'm trying to integrate Smartsheet and QuickBooks Online using Zapier. I'm having two issues: When I use the trigger "When a row is updated" it looks to see any time the row is updated. I only want to send to quickbooks when a specific CELL in that row is updated. Is there a way to do that? (The workaround for this…
-
Oauth Revocation / Revoke / Webhook
Is there an outbound (from Smartsheet -----> to our app) token revocation /deletion API call our app should be catching and handling? If the end user revokes our app's connection via their Smartsheet dashboard, does our app get a call? I checked the OAuth documentation and Webhook documentation and did not see it. Would be…
-
Direct personalised and specific help to customise my project setup ?
Hi , is there a list of experts or service / hire , who may be able to help me with the detail and specific project setup and reporting and cost management ? i've got all the info but having trouble getting it all humming with costs, dependencies, reporting and dashboards want to try to link with xero once somebody helps…
