-
Copy Specific Columns From One Sheet to Another, Linked
Add the ability to specify the columns to copy and link from one sheet to another in the Copy Row automation.
-
When setting up alerts to send to MS Teams, Im getting the Approval required message
When setting up alerts to send to MS Teams, Im getting the Approval required message, May I know who does this goes to, is it the MS Teams Admin, MS Office admin, or Company Smartsheet Admin? And where can I find that?
-
Total Hours with the same person assigned
I have created the below sheet. I am trying to total the hours used for rows matching "person" E.G In the first row "Richard Irwin @ FM" I'm looking to total the rows below Project Staffing that have Richard attached to it in the column "Person" Any ideas?
-
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…
-
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…
-
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…
-
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…
