-
External form and API 2.0 to insert a row in C#
I am attempting to use an external form (on our website written in C#) and the API 2.0 to insert a row into a sheet. I am reading the API 2.0 Documentation (at http://smartsheet-platform.github.io/api-docs/?csharp#add-row(s)) but cannot figure out where I place the actual values submitted from the form within this code to…
-
New data detection
Hi I was trying to find if there are ways for smartsheet to push new row data into a database. Like when Person A modified Document X. Then through API smartsheet will send the newly modified data (rows) to the database to add to the database. I'm not sure if this can be achvied or not. But i do see that it can send out…
-
ticket system \ Sharepoint integration with Smartsheet?
Hi all, My projects team are using Smartsheet to manage company projects. We now need to also manage some company’s tasks in a tickets system. Normally the company uses SharePoint for the internal ticket system. I would like my team to use only 1 system, Smartsheet. The issues are: 1. I couldn’t find and formal…
-
Syncing Smartsheet Calendar with Google Calendar
Hi I would like to sync my smartsheet calendars with a google calendar so that I can have one centralised calendar for all of my sheets. However, when I sync them, I loose the conditional formatting (which I use to colour code the different types of tasks/appointments in smartsheet). How do I maintain the colour coding?…
-
Authentication when accessing from Tableau using ODBC
Hi there, I use Smartsheet as one of data sources in Tableau. I would like to know if all work fine when using someone else's Smartsheet Access Token. Edit Datasource User name and Pasword - owner of Smartsheet I will add screenshots also.
-
What is the best way to associate prospect contact information and sales tasks to a smartsheet sale
We currently use smartsheet for our sales pipeline. I love it. As our prospects move through our sales cycle, we simply move them down the list. I use the formulas to track all of our conversion rates and apply to project types and marketuing sources. I find this reporting and linking feature invaluable. We use the…
-
Moving Uploads from a Sheet to Google Drive
We would really need a feature that allows us to move uploaded files from Smartsheet to Google Drive and have a link to this file in Smartsheet instead. If Smartsheet is not offering such a functionality might it be possible to find a thirdparty app that offers this? Any idea would be appreciated.
-
Why doesnt my assign to list match my smartsheet contacts that I spent a lot of time setting up?
Why doesn't my "assign to" list match my "my smartsheet contacts" that I spent a lot of time setting up?
-
api 2.0 update of a cell and "Invalid row location."
I am attempting to do a cell update (in python) and it keeps telling me "Invalid row location" and I am not sure how to track this down (or even why the row location is invalid). The call is: sheetURL: https://api.smartsheet.com/2.0/sheets/<sheet_id>/rows data: [{'cells': [{'columnId': '<column_id>', 'value': 'updated'}],…
-
Change Management Solution
Does anyone use Smartsheet for Change Management scheduling? We are in the process of creating a change management committee and are currently housing our Change requests in Lotus Notes Database.... Which is less than desirable. Trying to see how we could use Smartsheet to accomplish this... Anyone currently doing this or…