-
Custom Fields and JIRA Ticket Imports
My company is using a Smartsheet which uses custom columns fed by a request form. The purpose of this sheet is to process and track product enhancement requests, and occasionally we will migrate JIRA tickets into the process as well, which is what I'm setting up the connector to accomodate. The problem I am having is that…
-
How can I detect "Sheet - Create" using API
Background * We will be creating / managing projects in Smartsheet * Each new project is a new sheet, based on a template * I am designing integration to other systems that need to be notified whenever a new project or task within a project is created. * I can use a Webhook to detect changes within a project (sheet) * It…
-
CMMS Build up
Hello, Am working with a company as an IT which needs a CMMS tool for their mining clients for the WR, WO, PMs, AMs and so forth. And I need an expert of Smartsheet to help me on contract to develop the tool for them.
-
remove column ids, row ids from Smartsheet json!
hi team, I need help with removing the overheard data from the Smartsheet api call that returns a json file, I need to remove all the overhead before putting the data into the pipelines, thanks.
-
Navigate URL Automation
Hi Team, Is it possible to automatically navigate to a URL added in a cell if specific cell value changes to specific value? Please see below to understand the requirement. I have a tracker sheet for each project. Each tracker sheet having multiple task and once all task completed a formula cell shows to project completed…
-
Can Smartsheet get data from custom HTML forms on a website?
Hello, If I'm building a website, can I create a custom HTML form and get the data into Smartsheet somehow? Smartsheet's native forms don't have the capabilities that I need (conditional logic) and I would like to make my forms a bit prettier. Thanks in advance!
-
Update date field error
Hi. I'm trying to update a cell on a row which is a data field using the C# api. However, I'm getting an error {"Value is not supported for this column type. Use objectValue instead."} But when I'm trying to set objectvalue i get an error due to protection level I know I'm doing something wrong, but i dont know what :P
-
Using Microsoft Flow to Send Email
Hello, Currently Smartsheet doesn't allow me to send an Alert with an attachment. The context of this is for a travel spreadsheet, when someone enters their itinerary, it will send the person an email with a standard email containing an attachment of various do's & don'ts. I think I've got my flow set up ok but I'm…
-
Add Image (via binary not file) as attachment (and in cell)
Hi, I am using the C# API to interface to Smartsheet.... I can see how to add attachments and images in cells but these only accept a file name as a parameter. My images are stored in a database, is there a way to upload the images binaries instead of from a file name ? thanks Dave
-
Unable to update a Summary field of type DATE using the C# SDK
Hi Smartsheet Community! This is my first post and I hope not to scare you away. I've been finding the community amazingly helpful in everything I've been doing so far. Now I'm blocked and I hope someone can give me a hand . I'm trying to set a Summary field "Project Due Date" across multiple sheets.This Summary field is…