-
Group Multiple Automations into "Folder"
Hello. I have an approval sheet with 11 categories. Each category contains automation workflows with between 5-7 steps each. My workflow window is very messy and complex. Is there a way to group each category of workflows into a "folder", or some type of set? If I can do this, is it possible to clone an entire set of…
-
Recurring Task Tracker
Good afternoon, I set up a recurring task tracker for use by different groups within my department but am having trouble setting up the recurrence for automation. I would like the automation to begin the 25th day of each month (irrelevant what day of week) and repeat for the next 21 calendar days. As I go through the…
-
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…
-
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.…
