-
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…
-
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…
