-
change reply email on automation
Hi, I setup automation on my clients' smartsheets systems. Now I have many emails coming from their subcontractors who reply to me when they receive an automatic update request. How can I stop it happening for existing setups prevent it for future clients thanks, Lauren
-
Forms Automation
I have created a form and have set up an automation that sends the form link to a customer. When the customer opens the link from email the form is different than the form I created. It includes the customer email address as a drop down box and the customer can see other customer email addresses. Also includes a upload box…
-
Trigger Move Automation
I have a automation that is not being triggered, here's the setup: formula to number the time a value appears (1, 2, 3, 4, 5, etc) in the Duplicate column Move Row automation triggered when there are any add/changes and Condition a. Duplicate is one of 2, 3, 4, 5 b. Duplicate is not 1 c. Duplicate is equal to or greater…
-
How to auto-populate hidden values for forms?
Hello, my name is Matthew, and I am working on a project that gathers data from clients. The goal is to receive documents from them and have them uploaded to SmartSheet. I would like to be able to send them a form based off a contact cell, but I am having trouble with this. The other issue is, unless they type what we have…
-
Need Workaround Ideas for Automation Condition
Client submits file through form. I have an automation set up to respond to client when new file w/response is attached to row and "Status" and "Date" cells @row are populated. It works as intended but relies on people to always set those 2 fields and save before attaching the file to the row. Without the conditions set,…
-
2-steps Automation not working
Hello, I want to set up a form for several kind of requests. Once a request is created with the form, the idea of the automation I want to set up is to send an approval email to a first person, according to the type of request initially chosen in the form (this part is working fine), and once this first person approves, I…
-
Automation - Alert based on Date change in a column
I have a sheet with 2 dates, original ship date and current ship date. I want to send an alert when the ship date changes, but not when the info is entered for the first time. Or, to not send an alert if the ship date is the same as the original ship date. In the conditions, I can't seem to find a way to do this
-
Set up automated workflow to copy child rows to another sheet?
I have a sheet set up with parent rows for each month. I want to copy the child rows underneath the "July" parent row to another sheet using an automated workflow. What condition do I set if I want the rows under "July" to copy to the other sheet on the first of every month?
-
Ability to automatically update end date on a row, after row is created based on create date
We are currently using a Form to submit requests for changes and would like to use logic to update the end date of a row after the form is submitted and based on the create date plus X number of days OR after a status is updated, if the end date is blank update the row based on X number of days. Is this type of function or…
-
Approval workflow validation
Is there an easy way to validate that a request for approval submitted via a form is not approved by the person who created the request? My sheet contains a Contact List column from which approvers are selected. I have tried to validate this entry against the 'Created By' column but this does not match as the contact list…
