-
Make Collapse ALL default
I have clients with indented children. Everytime I come to the sheet the children are fully expanded. How do I make Collapse ALL the default setting? Matters not if I save it as collapsed.
-
Alert a user when an automation isn't going to work
I have a sheet where there is potential for an incorrect email to be added via a form (SS requires an email be entered for it to populate correctly into a contact column if not in the SS directory-if you have a fix for this, I would love it!). As the owner, I am notified when a user will not be alerted due to an incorrect…
-
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!