-
Autopopulated customized response after form submission
I don't think this is an option, but here goes. I have a form connected to a smartsheet that references another smartsheet to autopopulate text information based on a selection in the form. Instead of someone having to either 1) go in and view the autopopulated cells, or 2) the smartsheet owner emailing the submitter the…
-
Auto populate a cell when inserting a new row
Hi all, I am creating a project plan with RAG symbols. However, when I insert a new task / row, I would like the green symbol to auto populate rather than remain blank. Is there a way to show this as the green ball when inserting a new row? (Image attached). I would like to do this without a formula if possible. Thanks in…
-
Automation > Action Block : Create a new Grid sheet from a template
Is it possible to trigger an action block that will create a new Grid sheet from a template? I'm trying to create an automation wherein if a new row is added to an existing grid sheet it will trigger the creation of a new grid sheet from a template and copy the details of the new row.
-
Copy Row Automation - New Row Remains Linked?
Hello, When using the copy row function in automation is there a way to designate the copied row as linked to the source row? The easiest use case to explain this function would be a Risk Register Rollup where projects maintain their own RRs and when new entries are made it sends those rows to the RR rollup. As status…
-
Dates in Exporting Reports
Hi - does anyone know of a way to add a date to the title of an excel export so when I automate updates each file is dated? Right now it sends just the report name each time.
-
Sending approvals through email?
I see that Smartsheet has the ability to let someone know they have a task due by sending them an email with the task details. I am wondering if it is possible to subsequently send an email on Due Date +1 to say "you had this task due yesterday, was it completed?" with a Yes or No button for them to click. If they click…
-
Date Regenerating
Hello, is there a way to have information associated with a date to regenerate Every so often? For Example, we have a sheet that has an expiration date "Designation Expiration" and all the information after that is related to falling within that time period. We would like to have all of that information repopulate Every…
-
Dynamic Fields Issue - Subject Line Issue
So... intermediate knowledge of Smartsheet. Weird issue. I've tried messing with the syntax and arrangement... Subject 1: "{{MeetingID}} - Notes" Automation Email Subject 1: "Changes to Meeting Log - Project: Project Meeting Minutes" Subject 2: "{{MeetingID}} - Action Assigned" Automation Email Subject 2: "Team Huddle -…
-
Control for Character Entry on Form
Hi there - Is there a way to control the characters used for a form? I would like to limit to just roman letters. If this isn't possible, a suggestion for a work around on the grid? ie. We have event rsvp that are entered in Chinese characters then have to translate later. Would prefer to restrict on the form itself.…
-
How to ignore blank cells when stringing cell values together
Hi everyone! Hoping someone can help me out. I have created a Smartsheet form that someone can fill out to create a custom URL. On the backend of the Smartsheet, I have a formula set up to string all the values together and add delimiters into a url string. It works great, with one exception. All of the form fields are…
