-
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?
-
Set date in month column when another column used to set the date when task was completed
Hi Smartsheet gurus I have a need where I want to auto update a column corresponding to its month where in another column is used to set the date a task was completed - the need is to sustain the past months date in the month it was completed column - example - see attacehd sheet
-
Primary Column
Hello everyone, I am using Smartsheet to manage a product database. The master sheet contains all the relevant data company wide and it automatically passes the information to specific sheets for certain regions based on automation. I created a form that allows me to add a product to the master sheet but I've run into a…
-
Automated Workflow for Linked Cell Copying
I am trying to create a workflow that, when a new row is created, will copy over to another sheet. Also, when that row is updated, I would like for the changes to be automatically reflected in the second sheet. Right now, I have to link these manually, but would prefer to set up the linking in the workflow directly. Is…
