-
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.
-
Date calculation formulas are not working properly.
Hi, community. I have a weird problem with my metrics sheet and the dashboard linked to it since it is displaying fault information with a specific formula. I have tried a lot of workarounds, including the update of both source and metrics sheet and a lot of different formulas but I can't still fix it. Formula is as simple…
-
Add HTML formatting in Automation Workflow Notifications
Would be great if we could force wrap text within an Automated Workflow Notification Alert "Message" using </br> HTML tags, and/or be able to <bold> text directly within the Message we're setting up. Hoping this can be an enhancement one day to Smartsheet.
-
Approval Workflows with Inconsistent Reviewers
Background: I want to make a sheet that can track all of my review/approval requests throughout a project. I would want multiple types of project documents to be reviewed/approved (e.g., change requests, project charters/plans, test cases, etc.) each with their own set of reviewers/approvers. For instance: Project Charter…
-
Inventory Management
I'm looking to create a sheet to manage our department's inventory of swag/give-aways. I currently have the asset management template set up and running and am using the barcode functionality which is mostly serving our needs. The one gap I have is inventory updating. Ideally, when someone takes inventory, I would like for…
