-
Capture Row history using API?
I am trying to build a UI using Google scripts to display the changes made to any given row. In other words, I want to capture a list of modified date, modified by and what was changed in a row if any cell in the row was updated.
-
How to auto-populate/insert 10-15 task rows as child items under new project row?
What is the best way to automatically insert a set of (about 10) rows as child tasks under each project row? I am designing a smartsheet based on the Project Sheet template, but in my case we manage a large number (about 150) of projects. Each project is fairly simple: each project contains the same set of 10 tasks. I want…
-
Alerts For When Nearing 5000 row Limit
Is there a way to set up an alert on a sheet for when it is nearing the 5000-row limit? Thanks!
-
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…
-
Smartsheet relational database
Hi all, Im wondering if it is possible to set up a relational database using smartsheet and cross referencing other tables (which it looks like it is), however, i'd like to also be able to query these tables for specific data. Is there a way to query linked sheets or does anyone have suggestions for tools to use in…
-
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!
-
Automatic antick
Hello, I have a particular situation: 4 columns defined as checkbox. The description of the columns reflect a sequence: Open, In progress, Pending and Closed. I need that when I tick a subsequent columns/status the previous one (or the others) will be automatically unticked. Could you please help me? Thanks and regards.
-
Automatic data related to the check of another cell
Hello, I need that the data insert in a cell (column Data Open) will be automatically determined in relation to the data when the related cell of the row was ticked. Could you please help me? Thanks and regards.