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 …
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.…
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 a…
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 find…
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 ve…
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 pop…
I have an author schedule for a weekly blog that I would like to use to send out an automated reminder email to the assigned author each week. They don't need to go into the sheet to update anything, …
My PMs are noticing that Autosave in Board View is triggering automations for sending the assigned person updates on their tasks before the PM has finished making updates to all necessary information …
Good morning, friends of Smartsheet, I need some help working through a process. I have a worksheet that has a checkbox column called 'escalate'. When we check that box, the row shows up on a report t…
