-
Automation - Manage Workflows - Copy Rows to New sheet?
i see a feature in smartsheet to ' Copy a row to another sheet when specified criteria are met'. Is there any option to 'Copy a Rows to New Sheet when specified criteria are met' ?
-
Sending Update Request to A Multi Contact Field
Hello, I have a update request automation that should go out to a contact filed, that is set for Multi contacts. The emails are not going out. IS this a limitation to smartsheet that does not allow these to go out when you are using multiple contacts. can I only use a single contact field for this? Or should this be…
-
Searching keywords from a list of words?
Hi, I have two sheets, say Sheet 1 and Sheet 2. Sheet 2 contains a list of words in one column (i.e. "Keyword"). Sheet 1 contains a column with status updates (i.e. "Comments"). I would like to set up a formula that searches if Sheet 1's "Comments" column has any matching keywords from the list of words hosted in Sheet 2's…
-
Nesting IF, AND, and OR
Hello there! I am working on a project that will allow us to do a very quick visual check when a date is inside a work window. The problem occurs when a work window has two date ranges, this example being 07/16 to 07/30, and then another work window between 11/15 and 02/01. Not all work windows have two work windows, but…
-
Automation - Manage Workflows - Copy Rows to New sheet
i see a feature in smartsheet to ' Copy a row to another sheet when specified criteria are met'. but here is no option to 'Copy a Rows to New Sheet when specified criteria are met'. i need this option as we are converting our database from Access to Smartsheet.
-
Proper Safety Management System (ISO 45001)
Has anyone created a successful Safety Management System using smartsheet? If so, do you have a template?
-
Can I set a recurring event and reminder in Smartsheet?
I have a project plan that I am working on that requires certain tasks to be completed weekly, monthly, or quarterly. Is there a formula or automation that can be used to make a task recurring?
-
email notification
I would like to set up my orientation registration smartsheet to send an automatic email to the person submitting the registration form confirming the date of the orientation. I do not want to share the sheet with everyone completing the form. I have a contact list column (this is who should receive the email) and an…
-
Why won't my automation to record dates work?
I am trying to record a date for each of our statuses listed below. Approval Pending, Approved, Denied, In progress, Completed, and Removed Most of these statuses are updated by a formula when dependencies are met on my sheet. The formula for the statuses is working correctly, but for whatever reason the In progress,…
-
Reference worksheet name in alert automation
Please see the attached for reference. I have an alert automation to let my reception to expect bid submission on a triggered date. When I look at the email, attached, there is absolutely no indication as to what worksheet the automation came from. How do I fix this so that my admin will know the name of the project…