-
Workflow OR conditions
Hello, I am creating a workflow for notification (send out alert to my email address) while I have some questions about setting up the condition. It's a sharing sheet that people need to get into and update some fields. I have Column: Type - indicates the employee is a new hire or being terminated. Column: Date (to be)…
-
Retroactive Workflow Solution
Hi If I create a workflow to copy rows to a new grid, will it work retroactively if the criteria was met before the automation was created? For example if my "approved" column has an "If YES move to new sheet" workflow added tomorrow, would anything that has YES in that column from today also move to that grid? Thanks Dan
-
Automation - Change Linked Sheet
Hi All Is it possible to change the linked sheet in the email that is received through the automation workflow? Here is my challenge // Automation - IF Status Change from GREEN to RED THEN notify individual and COPY ROW(s) to task sheet Notification Email - Hi [Name] the following items have changed status, please review…
-
Automation - Sheet Update based on Criteria
Hello again Like a typical N00B I'm having wonderful ideas with almost no knowledge of the product (go easy, I'm just rolling into my 5th hour in 2 days of using it) I wanted to know if anyone has any experience or thoughts on how best to approach this scenario as I've found some challenges with my current workflow…
-
Workflow - recognising email domain as part of "assigned to" column
Hi all, I have two columns: Assigned to - this is set as the "contact list" property and linked to the address book so you can put an email address e.g. "firtstname.lastname@smartsheets.com". However in the field it would show up as "firstname lastname" without the domain at the end Company - dropdown box with 2 company…
-
Blank Automation Notifications
Hello, I have a number of automated workflows setup using Dynamic Cell Data in the subject lines and message bodies. This morning I was informed that some received message with blanks were the Dynamic Cell Data should have been. Has anyone experienced this issue before? No columns had been adjusted prior to cell changes.…
-
Alert when Checkbox Column gets Unchecked
I have a formula column that gets checked or unchecked depending on some other things in the sheet. An alert goes out when this gets unchecked (and when rows get changed, not added) on an hourly basis. We recently got an alert saying that a row got unchecked but it makes no sense. I checked the cell history, and it was…
-
Collecting Dates in a Reoccurring Approval
I have a sheet that needs to be reviewed and approved by multiple individuals on a regular reoccurring basis. I have already set up the workflow for this to happen but I will need to keep a list of the dates they were previously approved. Is there a way to use a formula like Join/Collect to do this? When I try it will just…
-
Email Limitations for Email Alerts?
Is there a known bug that prevents email alerts from being sent to a generic or non-individual email? I have a workflow set up where the final step is that an email alert goes to a one of our office services staff for each office depending on the input from the form itself. For example, if the attorney is in the NYC office…
-
Add logic to a form on workflow automation
Hi there, In forms, we are able to add logic to the form so that is a value is selected, an additional field appears or not depending on that logic. (e.g. we have a field that we ask "Yes or No" - if answer "Yes", nothing happens, if answer "No", then a new section will appear asking "please explain why". In automated…