-
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 😊
-
Values are missing when creating a condition in an automation workflow
Hi - I am trying to create a 'Request an update' action on a workflow, but when I try to create the Condition and select the appropriate values, not all values are available to be selected. Only 4 of the 6 values are available.
-
Update Request Automation - Single v Consolidated messages
Hi, Hoping someone can shine a light on how update request notifications work. I have a list of projects in a sheet which I would like the owners to provide weekly updates for; some have multiple owners, other tasks have only one owner. I've set-up a few automations to test the different messages owners would receive but I…
