-
Automation: "Copy Rows to Another Sheet" Isn't Working
Hi, I am the owner of a project that has several Smartsheets. When someone (owner/admin) changes the "Status" column to "Req. Not Met," I want the row to copy to another Smartsheet. I set up this automation. Then, I updated the "Status Column" (in five rows) to be"Req. Not Met" and saved it to trigger the automation. Next,…
-
Missing Attachment as Notification Trigger - Smartsheet Automations?
I have built out a multi-use form that, depending on the user, requires attachments to be added. Since I cannot conditionally require attachments in the form I am trying to build an automation that triggers a notification to the form submitter if they neglect to add an attachment when it is required... but I continue to…
-
Automation to send form for a sheet at specified cadence
It would be nice in the automations to send out a form at a specific time, weekly, monthly etc. to emails so staff can be reminded to send over form responses on a project. Not an update, but fill out a form from scratch.
-
Cross referencing same range across multiple sheets
I am using one sheet, call it Program Data, as my source data for piping into my many Project Sheets. The Project Sheets have a Project ID in one cell that determines which line of the Program Data sheet to call out (e.g. Start Date, Team Lead 1, Team Lead 2, Team Lead 3, ...). I can't find a way to link each cell without…
-
How do I create an IF functions that will change my status color if information is in the cell
I am trying to have my event status which is (symbols) update to gray, red, yellow, or green depending on if 2 cells contain information (Green), or one cell or no cells have information and is more than two weeks from the date (yellow), one or no cells have information and is less than two weeks from the date or event is…
-
Merged: Approval Flow support more than two buttons
This discussion has been merged.
-
Is an automated export of a Smartsheet to an Excel file possible?
Hi all, I have been having the most frustrating conversation with Smartsheet support on this topic and not getting answers to the question that I asked. I would like to set up an automation that will email me an Excel copy of my project plans on a weekly basis (or when triggered with a change - I don't really care) as I…
-
Can I create an automation on a template in a toolkit?
Hello Smartsheet Community! My question is: Can I create an automation (e.g. to notify someone with a specific message) on a template in a toolkit that will carry over when new projects are created?
-
Merged: Updating distribution list for Auto delivered reports
This discussion has been merged.
-
Automation Error - Notifications
I'm having an issue with my notification workflows when someone submits a new request through a form I created. I recently updated the 'Submitted By" field on the form to a drop down option so those submitting new requests can type their name and their email address auto populates. Previously, the field was left as open…