-
How can I take a concatenated string and feed it into a form as an option?
Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form. In the sheet, I have a 5th column that concatenates all of the 4 fields. (It basically builds a unique name for each of our customer audits) and looks like this.. 2019_Jun_Fab5_Skyworks…
-
Can I Auto Assign Tasks to Myself?
When creating a new task can I have it automatically assign it to myself?
-
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…
