-
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…
-
Integrate with Bank Feed
Can I integrate a sheet with my bank (Lloyds) to automatically download new statement lines every 30 mins or so. I have to login to my bank and copy the data across all the time and would like to automate it if possible.
-
Live Tracking User Metrics Using Power BI
Hello smartsheet Community, I want to track company smartsheet user metrics such as the number of users, number of sheets, user types, etc. automatically using Power BI. Currently, I am exporting the user and sheet access reports and having to combine them into a single view before displaying the data in a meaningful way.…
-
[PYTHON API] Adding an new row with date column
Using the python SDK, I'm having trouble adding a new row to a sheet where one of the columns is a DATE column. For ex, doing: cell.value = datetime.datetime.now() with the column type as DATE doesn't assign anything to the column, and the request comes back with an error since the cell.value is empty. If online I switch…
