-
Get cell value by api rest
Hello, We need to get a specific cell value given the row and column id via an api call. I get one way getting the history of the cell but this call has a problem when you call more than 10 times in a couple of second, do you have another solution? Thanks Miguel
-
Milestone Tracking Report - Numerous projects
Hi all I'm trying to create a status report which would roll up project tasks and their progress into an easily view-able report and/or widget The data will be across multiple sheets and I'm trying to find a way to trigger both active, complete and in progress data sets so that I can target the relevant stages inside of…
-
Security concerns with published links
We have enabled the link public publish for our organization's users; however we want to purge or expire these public links after the need is over; because we are sure most users won't remember to toggle the public link off on the sheets or reports. I know there is a report that admins can generate that shows all published…
-
Renaming Reports - updateReport() functionality
There has been very little discussion on this topic. What is required to get this feature added to the API? I have been assigned the task of creating a JAVA app that will create new workspacea from a set of templates we've created. This is to be done through the JAVA API(SDK). I've completed the app other than renaming the…
-
JIRA Pro Fields
Has anyone used JIRA connector to update cells in Smartsheet from Pro Fields? This is a main functional requirement of our use of the integration tool and really want it to work if possible...Thanks!
-
Has anyone else had a problem when moving Smartsheet windows to a 2nd monitor?
When I need to work in multiple sheets, I find it easier to open several sessions of Smartsheet and have one on monitor 1 and one on monitor 2. But when I'd like to move the session I have open on monitor 2 over to monitor 1 and nest it at the top in IE, the right side of the screen inside the frame gets cut off. The…
-
Export only the photos from the user
Hi, can I export all the user's photo only? In addition, is any way to connect API with smart sheet?
-
Is Picklist always Strict through the API?
I'm trying to update cells via the API and one the cells is in a Dropdown list column. However, when the API tries to add a value to the cell. I'm getting a 1042, "The value for cell in column 7098131356849892, beagle, did not conform to the strict requirements for type PICKLIST." However, I've checked the sheet, the value…
-
completed task names auto skipping other tasks?
Hi, I am trying to create a project where depending on a certain task completing or not, the project sheet auto skips other listed tasks. This is very simple, but very hard to communicate via words what I am trying to do. For example, lets say I have a project that lists out how to drive a car. Task 1 is does it have gas,…
-
Dynamically Updating Row Information
I am looking to dynamically update add or delete a row in a sheet based on a checkbox on another sheet. Specifically, we have a sheet that contains all our outstanding balances, and a sheet that contains all our job info. We are looking to have it add a row to our balances sheet when our checkbox isn't checked, and delete…