-
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…
-
Workflow action to set a date to a relative date or static date
I am requesting a formula that would allow me to update a date with something other than today which is done with "record a date". I may want to record 3 days in the future or possibly a fixed date such as "12/25/2026". This would allow me to set fields that can be used for alerts while leaving them editable since they…
-
Merged: Rich Text Formatting in Workflow Emails
This discussion has been merged.
-
Workflow Action to increment a Cell value by some number
As a programmer there are many cases that I would like to take a number in a cell and add some value to it. I dont have a particular use case in mind currently, but this allows another tool in the box for coding complex systems.
-
Time zone discrepancy in Automations
Hello! Something strange has happened - my Smartsheet profile is set up for AZ time zone, and my workflows have followed that. However my Automation workflows switched to Eastern time today, so due to the time difference they all went out incorrectly. How could my Automation workflows run off a different time zone than my…
-
Column Dependencies and Formula Auditing
I wish there was a way to select a column/ cell and see all formulas and automations that reference it. Similar to Excel's "Trace Dependents" and "Trace Precedents." This could all be part of a formula auditing tool that would let you see all formulas on a sheet and which column they are in.
-
Pause Workflow until Update / Approval Request is completed
It would be extremely helpful if during a workflow, when you have an Update / Approval Request, you had the option to have the workflow not go to the next step until either request was completed.