-
Script Editor, Deploy as Web App, like Google Sheets?
Does Smarsheet have the following capabilities? * Script Editor mode to create Custom Functions, like the Script Editor in Google Sheets: https://developers.google.com/apps-script/guides/sheets/functions * Deploy as Web App: https://developers.google.com/apps-script/guides/web I'm looking to do something similar to the…
-
Regarding DocuSign integration: Is there any way to combine Workflow + attachments?
I'd like to use the workflow to have a variety of fields and the signees autofilled, but there doesn't seem to be a way to include an attachment from smartsheet in the workflow. Alternatively, I can create an envelope from an attachment in Smartsheet, but then I have to rebuild the fields every time and I can't have them…
-
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
-
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…
