-
Trigger "when rows are added or changed" doesn't work
Hello all, I have created a Workflow to send a weekly email notification when rows are added or changed in a Sheet, but it doesn't work with "Run Now". It doesn't detect any of the changes made. I have created this Workflow on other Workspaces and it works fine. If you have any idea, why in this case it is not working, do…
-
Why is my destination sheet not showing for copying a row in a workflow?
I can copy a row from my original sheet to my destination sheet manually, but the destination doesn't show up when I try to set up a workflow. I have admin access to both the original sheet and the destination sheet. Any ideas? The images show how I have access to the UWM Shipping Record under "Sheets", but when I open…
-
How to capture Actual Finish Time for a Cutover Task
I have created a cutover Plan in Smartsheet and all tasks in the plan has these columns : Task, Duration, start Date and Start time, End Date and End time, Actual Start and Actual Time, Actual Finish Date and Actual Finish time. I am able to calculate start and end dates based on duration but I’m only able to capture…
-
Multiple Automated Workflows Triggering for same item
Hi! I have helped design a Smartsheet that we are using to track requests. There are three scenarios that we need to capture, and each scenario has a slightly different workflow because certain approvals are or are not required along the way. I am running into an issue when the request is declined, all of my workflows are…
-
Turn All Automations Off or On
Sometimes i would like to implement changes to a sheet that would trigger automations that i don't want being sent out. One such sheet has several dozen automations. Turning them all off, implementing my change, and turning all the automations back on, could be a faster process.
-
workflow, not seeing other sheets
I've been added as an admin to an original sheet, I'm trying to create a workflow to copy lines, that meet a certain criteria, to a sheet I've created, but when I'm in the workflow I see no other sheets to be able to copy the lines to. I've created similar workflows before and have not had this issue. The only difference…
-
Workflow Automations being sent out on a different levels of data within Intake Sheet
Hi all, I'm trying to solve an obstacle I came across when building Notifications in the Intake Sheet. Let me shortly describe what I'm trying to achieve: Above is an example of the Intake Sheet that will act as a scenario for my question. I have a Primary column, which is a combination of different values from two columns…
-
How to write notification so it only occurs on change to field, not on row creation?
I set up a notification for some users to be emailed when Lead Unit changed to theirs but they are receiving notices about new entries assigned to them as well. How do I write the notification to trigger only on a change to existing text, please? My thinking was to check anything that was more than 24 hours old and send an…
-
How do I create one sheet that automatically ingests data from other sheets?
Howdy community! I have about 90 different project plan sheets that there are static cells I'd like to pull information in from. Those I have already created on a different sheet by using a cell reference. Easy enough. My struggle now is there is a separate sheet for all 90 of those projects that contains status updates.…
-
Create Triggers Module Issue
I have a series of sheets that I need to create triggers for that I am trying to scale via automatic trigger createion. We have a custom module in Bridge for both Create Triggers and Create Templatized triggers. I've tried using both, and while it says completed in the run log, they do not show up on the identified…