-
Why can't I use hourly, daily or weekly on this automation?
I'm trying to make a daily notification for the automation below. But it won't allow me. Can someone provide ideas of what I'm doing wrong?
-
Automation - Moving rows and changing cells
I am creating a sheet (Hire Sheet) that will list our field employees along with their hire info. On this sheet, I have a column named Term Date. Once a term date has been entered, I'd like the row to be moved to another sheet (Term Sheet). I have that sheet created to have the same column names as the Hire Sheet and also…
-
Last Modified by User
How do I track the last modified date by a user per Row? I could use the built in one but the automation tool is overwriting the last modified date.
-
Control Center - Automation (Auto Provisioning)
First question in the SS community :) I set up an automation config in SCC but haven't seen anything actually get provisioned yet. The automation config is enabled in SCC. The intake sheet does have rows that are marked as "ready to provision" via a check box. I've deleted and re-created the automation config with no luck.…
-
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…