-
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.…
-
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…
-
Turning on Resource Management triggered automation???
Help please! A teammate turned on Resource Management on a critical sheet for our day to day operations. This seems to have trigged automation that archived all rows. While I can see the rows that were archived, I am reluctant to move them back without knowing How to identify the automation that was triggered in the first…
-
Is it possible to email only some information from a sheet via workflow?
As an example, say I have a sheet with data columns: Name - User ID - Phone - Address - Email The data is entered via a form, and I need to set a workflow to email all contact information from new entries to another team for various system updates, but User ID is sensitive personal data and cannot be shared. What is the…
-
Can you create a workflow that emails the line attachment as an actual attachment instead of a link?
I have a smartsheet that creates a certificate once the user details have been entered, then emails a copy of the certificate to the user once an email address has been added, but would be better if the line attachment was attached to the email instead of just a link to the attachment.