-
Automated workflow not working for all users
I have set up an automated workflow to alert individual team members of their assigned tasks. There seems to be a problem with some users not receiving the notification when I set up the assigned task. These users do receive emails when a comment is directed to them. This problem seems to be independent if you have a…
-
Automated Workflows to retrigger after decline
Hi Team, The Requestor/ initiator is not someone who would have access to the SS tracker. The person would simply update the required fields and submit the form for next step of approvals. I have build the form for 4 approvals levels and it works fine when each level just hit APPROVE and not decline. However, if one hits…
-
How do I set up an automation to send emails triggered by date/time instead of a Smartsheet change?
I've been able to successfully set up an automation workflow to send notification emails triggered by a change in rows on the Smartsheet, but is there a way to make the trigger a time of day? I've set up an automation workflow to try and send daily reminder emails at a certain time every day, but it's not working (see…
-
How to add time or subtract time from a date when "check" is selected?
Hi! Looking to see if this is possible. I have a packaging release date column that current pulls from another sheet for all items. I have items for Disney that I need to subtract 30 days when I click Disney checkbox column. When I uncheck the checkbox column, I want the date to revert back or add 30 days back. Here is the…
-
Copy of Template loses Alert Someone Email address in Automation
Hello, When I "Use" a template to create a new sheet, most of the automation remains, but the email address in the 'Alert someone' section gets erased and the Automation 'Saved Workflows' say UNABLE TO RUN. How can I get the template to keep the Automation workflows intact when I use the template to create a copy? I…
-
Automation on columns
I would like to set up a notification automation for when all the criteria in the column is met. For example, I have a column that includes a checkbox with the column labeled "complete". I want to receive a notification when the last checkbox in the column is checked, so that I know that all tasks have been completed on…
-
Issue with text parsing on date/time populated by automation
I'm having an issue where I have a created date column, then a date column that referenced the created date column and uses text parsing to remove the time. formula below: =DATE(VALUE(20 + MID([Issue Opened Date]@row, 7, 2)), VALUE(LEFT([Issue Opened Date]@row, 2)), VALUE(MID([Issue Opened Date]@row, 4, 2))) This functions…
-
How to change Automation Trigger from "Changes:" to "Changes To:"
Hello Community, I have set up a sheet and a form. The form has various drop-downs asking different fellows for their unique identity numbers. I am trying to copy the rows to the fellow's specific sheet when the drop-down is their unique identifier number. I am setting it up for 20 fellow drop downs, out of these the 19…
-
Conditional copying of rows from one sheet to another
I am building an inspection sheet and form where our operations team will be able to mark pass/fail through a checklist. If something "fails", I want that specific row in the inspection sheet to be copied over to another project tracking sheet. These two sheets will necessitate different fields. Upon the specified…
-
Counting days of ticket open but starting at 0?
I asked this question before and got a solution but now it is counting starting at 1 instead of 0. this is the formula used =IF([Date Closed]@row = "", NETWORKDAYS([Date Opened]@row, TODAY(0)), NETWORKDAYS([Date Opened]@row, [Date Closed]@row)) I tired using (today -1) but then it starts at -2. The date closed is an…