-
Automation To Alert of Any Field Changes EXCEPT Comments
I would like to send an alert to someone when any field in the row changes, except comments. How can this be done without having to set an alert for each column individually?
-
Send email Alert to those who haven' submitted their status for the day
Hi, I've been trying to figure out how to create an automation send Alert email to resources who haven't submit their status for the day. Can you help me or suggest on how am I able to achieve this? Thank you.
-
Date Formula Issue
=DATE((YEAR[Tactical Training Start]@row), (MONTH[Tactical Training Start]@row) + 1, (DAY[Tactical Training Start]@row)) ^^ This is the formula as it sits now. I'm trying to take the date from the Tactical Training Start column for a cell and add 1 month to the date for a different cell. What am I doing wrong?
-
Values are missing when creating a condition in an automation workflow
Hi - I am trying to create a 'Request an update' action on a workflow, but when I try to create the Condition and select the appropriate values, not all values are available to be selected. Only 4 of the 6 values are available.
-
Update Request Automation - Single v Consolidated messages
Hi, Hoping someone can shine a light on how update request notifications work. I have a list of projects in a sheet which I would like the owners to provide weekly updates for; some have multiple owners, other tasks have only one owner. I've set-up a few automations to test the different messages owners would receive but I…
-
approval when a row is marked complete
I am trying to add an approval when a specific row is marked complete. I do not see a way to do that. I want to add sign-off of a phase when the milestone is complete (eg. Task = QA complete Status = complete) Is there a way to do that?
-
Auto Populate an entire column with the 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…