- 自动填充一整列的value of one cell from another column
I'm trying to populate an entire column with a value from one cell from another column within the same sheet. Is there a way to automate this process. I would like the value that the arrow is pointing to populate the entire column "Project Name". I'm using the column as a helper column in the calendar app as a way to group…
- How to set up move row automation with formulas
I currently have a formula in place to "star" a row on sheet A when a unique identifier # from sheet A is added to sheet B. Then, I would like to move the row from sheet A to sheet C after the "star" is highlighted. I read the statement below in the smartsheet Automation article: "Actions that will automatically modify the…
- Automation Workflow Time setting
Hi, I am looking at the feature creating Workflow. I'm wondering is there any way that we could set the time trigger by minute? For now, we can only set up on the hour, however, is it possible to customized the setting by minute, like 2:30pm, 2:45pm? I am asking because when I test the workflow, I can only wait for another…
- 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…
