-
Can I copy cells to another sheet without creating duplicates?
Hi everyone, I'm looking for some help with automation. STEP 1: I want to copy row data from one sheet ("Sheet A" for simplicity) to another sheet ("Sheet B") when a status column is changed to green. STEP 2: I ALSO want to copy row data from "Sheet A" to "Sheet B" when an attachment is added. By nature, STEP 2 will happen…
-
Learn how to improve your work life with our live Smartsheet Workshops!
Want to spend more time doing the work that matters to you? Our live, interactive workshops are packed with expert insights and real-world applications that will help you uncover how Smartsheet can relieve the common pain-points in your workday – so you can focus on the work you care about most. This month’s…
-
Bridge examples including Javascript
Hi fellow Smartsheeters! In preparation for my session at Engage 2024, The future of workflows, I'm posting a variety of live Bridge examples to this thread. Each "block" will have a use case description, workflow layout, and (if needed) the javascript code I used. Enjoy!
-
Use Custom URL to add users to company account.
Use Case: 1. Account Discovery is enabled for company. 2. A user received a shared Smartsheet from a company Smartsheet owner. 3. User clicked on Smartsheet, and it sent him to main screen to create an account. 4. User created an account using his company email. 5. Smartsheet associated his account with the company. 6. A…
-
Automation - Trigger when date and time reached - change time to 15 min increment
When building automations, the handiest way to test is to set the automation to trigger when a date/time are reached. However, only having the option to set for the hour (6:00, 7:00, 8:00, etc), means that after testing, and discovering a tweak needs to be made, one must wait until the next hour to test again. This results…
-
Searching for specific automations
I have so many automations and when I need to find one to edit, duplicate, run, etc., with the existing filters (alphabetically, creation date, last refined date, etc) I still waste a lot of time finding what I need; I often don't know when I created an automation or last updated it, or what first word I used to sort…
-
Why i am getting one combined email when adding multiple entries in a form
Hi Friends Hope you are doing good and staying safe! I am using Automation>Trigger>Alert someone feature to get email notification when user submits the form. I want to get individual email for each entry, however if user submits the form multiple times with different data, i am getting one combined email instead of…
-
Microsoft Teams - Multiple Smartsheet Notifications via Automation to a Public Channel
I have created automations in Smartsheet (SS) to send notifications to a public Teams channel in my organization. This works flawlessly without any issue. I have another separate sheet in SS with a very simple automation that when a row is added to a sheet (via a form), it is to update the same Teams channel as the one…
-
Weird Trigger action on workflow automation
I have a workflow automation on sheet 1 that copies a row from sheet 1 to sheet 2 and sends an alert to my email when it is done. The cell that triggers the automation (a checkbox in sheet 1) gets populated by another sheet (sheet 3) and as such the rules say that the workflow will not be triggered and the row will not be…