-
Merged: "Reply To" in Alerts and Update Requests to be sent to a non-licensed email
This discussion has been merged.
-
Time Elapsed to Today in Months/Years
Hi! I'm trying to figure out how to use the NETDAYS formula to show how long someone has been a member of a certain team. I can't get it to measure to today using the formula that the website suggests. I want it to be running so that whenever I log on I can see the time elapsed to the day I'm looking at the sheet. Can…
-
Update Dropdown List
Is there a way to automatically update my dropdown list for a form if I have a new item added? I have a New Order Entry form. I have a dropdown list of customers, but if it is a new customer, there is a checkbox to allow more fields to open up to enter that information. If that information is added, it gets copied to a…
-
Record Approved By Email/Name
Hello- There's been a few question/discussions on this topic, but they are a but they are older posts. I'm trying to record the email/name and date when travel requests are approved. I'm capturing the approved date with a Record Date Automation, so that it easy, but the approved by field is getting messy. I'm currently…
-
Automated Email Option to show only completed fields within a Form
We need to have the option within the Smartsheet Automated emails to only show the fields (from a form) that have been completed in the email. Right now, the email that the customer receives if they request a copy of their responses is exactly what the option within the Smartsheet automation should look like. Right now, we…
-
Automated Workflow - Assigning Multiple Contacts to a Cell
I have create a project intake form for my program. In my form, I ask the user to select the departments that a project will involve (e.g., Communications, Product Development, Field Team, etc.). I then created an automation where, depending upon the department selected, a person was assigned in a contact column to the…
-
Error when trying to attach
I am using an automatic workflow to request a monthly update. In that update they will need to attach documents. When testing the workflow and trying to attach a small document I keep getting the error message: There was an error uploading the file 'xxx'. Please try again later.
-
CC'ing yourself when sending email to all shared users of a sheet results in hundreds of emails cc'd to yourself
Like the title says. I wanted to send an email to all shared users of a sheet. I checked the box for 'cc myself' and it cc'd me on each individual email it sent to each user. I received hundreds of emails in seconds all with the same subject.
-
Can the creation of timelines (from templates) be automated?
Hi - my organization has been using Smartsheet for several years and we're looking to automate wherever possible for consistency and efficiency. Whenever a new project starts, the PMO creates a timeline (save as new) from a template that's specific for that project type. The PMO manually updates the default value in a few…
-
Automation to Add Columns to Sheet Each Monday
Is there a way to set up an automatic function to copy a series of columns and paste them into the same sheet every Monday morning? We want to create a simple weekly schedule for our employees without going through the manual process of inserting rows before the previous week's schedule then duplicate the column titles.…