-
Smartsheet Automated Emails changing custom subject line
Good Morning, I've have several workflows setup to send out emails that are triggered by dates. I'm using the Alert someone and I have setup specific subject lines in each out these, based on the time frame of a requested completed date. This morning, I received a "Reminder: Smartsheet Name" email that was sent to all who…
-
Automations Inactive - Still Sending Alerts
We have a sandbox sheet duplicated from a live sheet for 6 months now. The automations on the sandbox sheet are 'inactive' as we don't want any alerts being sent out while we run testing. However, just recently, email alerts have been sent from the sandbox sheet to the contacts and we know this for sure because the link in…
-
Reoccurring workflow start based on date in cell and end when a condition is met
It would be awesome to have be able to set a custom recurrence for a workflow that is triggered based on a Date Field instead of a hard coded date. This would be extremely useful for Update Requests and Alerts. For instance having it resend the UR/ Alert/ Approval until a condition changes that shows they have responded.
-
Deactivate all automation on a sheet
It would be great to be able to "select all" when deactivating workflows in a sheet. I create templates and archive sheets and if I forget to uncheck the box then I have to go and manually deactivate each workflow.
-
Workflow Administration in Control Center Global Updates
I would love to see the ability to create, update, and administer workflows in Control Center provisioned projects. A few use cases: We recently completed our implementation of Control Center and migrated our live projects into the new framework. Some of the blueprint templates have alerts configured and it would have been…
-
Automation Notifications Using Groups
I would like to be able to use Smartsheet groups as recipients within automation workflow notifications instead of listing each user individually.
-
How to automatically add NA to a date column in 1 case, which is updated manually in other cases?
Hi, So, I have a date column, say Date A. I have another column say 'Condition A'. When 'Condition A' column consists of a value 'ABC', then Date A column should auto populate with 'NA'. In other conditions when Condition A column has 'XYZ' or @'PQR', Date A column needs to be filled manually by the smartsheet user. Now,…
-
Recover Data Shuttle workflows
For large organizations, allow Admins to recover the sheets, automation workflows and data shuttle workflows created by users who have left the organization and assign them to other users who took over the respective role. Currently, the only option is to start over, which involves not only time and labor, but also…
-
Resource Planning: Calculating Weekly Hours Remaining for a Project
Hello, Goal: To view estimated hours per resource per week. I am looking for a way to calculate the weekly hours remaining on a project, per person. I am referencing my project plan as the source sheet which has: Resource Name, Estimated Hours, Start Date, Due Date, Week Start, Task Name, etc. In a summary sheet, I would…
-
INVALID COLUMN error in "Alert Someone" Automation
Our team uses template project folders to easily create each projects schedule and trackers. We use the "Save as New" functionality attaching all reports to the newly created folders. Recently, after saving as new we are getting this "Unable to Run" notification for the automated notifications within our schedule. When…