-
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…
-
Automatically Copy Rows when condition is met
I am trying to create a workflow using the copy row feature when a particular condition is met and its not copying. I am the owner and the admin on both sheets. One of the things I'm trying to do is when I am assigned a task, I want to to automatically copy the row to a different sheet from where I plan to track tasks…
-
Do formulas work in Workflows?
Do formulas function in Automated Workflows by any chance? I have an AV Maintenance Sheet that is populated by a Form. Each row is a new record of a Room test. If a Room is checked and Fails, and the same room is checked again at a later date and passes; I am trying to ultimately move the older row with a Failed status to…
-
Changing an older cell based on criteria from a newer cell
Hello, Looking for a little assistance with a formula (or workflow), if even at all possible. I have a row of data with a Date, a Room and a Status of “Conditional Pass”. When that same Room gets checked again at a later Date, has a Status of “Pass” and a new row is added, is it possible to change the original Status entry…
-
Transfer/Copy workflows between smartsheets
Hello, Is it possible to copy workflows from one Smartsheet to another (similar) one ? Thanks. Regards 😊