-
Update request to a typed email address
I've got a form that drops info into a sheet, including a contact list. Right now, I've got several users plugged in to the field option, with automation sending them an update request when they get assigned a task. I need to be able to have a user type an email address in, and send that individual an update request. I'm…
-
Alert automation not working
Hello, I have a sheet that has a form, and I have set up an alert to go out to my colleague who needs to fill out the form every two weeks. Before the alert is sent out, any previous entries are archived to another sheet. My automation worked the first week, but has not worked since. Can someone tell me what is going wrong?
-
Avoid automation sending same email to contact listed on multiple rows
I have set up a sheet that lists every web page on my company's site and has a column listing the Content Partner who is in charge of that page. I have a workflow that alerts the Content Partner annually to review their pages. Often, one Content Partner will be listed for multiple web pages in any given month (because they…
-
Getting an image approved - how to set Approval Status from multiple cells, ignoring blanks
Hello! I have an image production process sheet that at the moment requires 1-3 approvers per image. The images to be approved live in a cloud drive - they do not get attached to the Smartsheet. Basically, when there is a contact email in an Approver cell, I need a formula to check what the Image Approval Status is. Here…
-
How do I use workflows to copy rows to another sheet when 1 of 2 conditions are met?
I have a workflow that copies a row to another sheet if one of 2 conditions are met. This was working okay yesterday when I was moving the rows (but not every time). Now I can't get the rows to show up in the new sheet whether they are copied or removed. If I select to have the row moved, it disappears but never reappears…
-
Why is an automated alert no longer working?
Our company has been using Smartsheet for over a year to organize the production process in our shop. Clients submit orders through a form, and when the order is added to the Sheet, we have an automated alert that is triggered to send a copy of the approval to 2 different email addresses. Suddenly one week ago, the…
-
Auto Functions w/ Update Requests
Hello, I am trying to figure out if there is a way to 1) automatically add a new child row once someone has completed an update and 2) send out a "report" of updates (children rows) with the update requests so the person who the task is assigned to can see their previous updates. As of right now I add a new child row…
-
Permissions
Hi I have an automation on a sheet that will ask for an update when a line item is due. Will the person assigned to the task receive the automation and be able to update, via the email form if the sheet has not been shared with them, or do they have to have the sheet shared with them to receive the notification and be able…
-
Two workflows in one automation?
Is it possible to have two workflows in one? For instance, if someone is filling out our intake form, and they select a marketing tool called "Emma", I want the specific marketing person who handles that tool to be assigned to that ticket and to receive an alert that someone has submitted a ticket for it. Can I make both…
-
Automation emails
My teams uses a process to send an email when certain thresholds are met. The recipient of that email is able to respond to the referenced row in SmartSheet. It would be useful for the assigned person to be notified when the recipient has responded. Is this possible?
