-
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…
-
Placeholder in automated email of sheet name?
I would like to be able to include the sheet name in a time based update automation which is a part of a template set. While we could make it a part of the set up process to update this automation manually with each new project, ideally we could just insert a placeholder for {{Sheet Name}} and have it fill in. This would…
-
February 29th Automations?
Hi all, This may be a silly question, but if I have set up automations on my sheets to be performed on the last day of the month for February to re-occur every year and it was set up on the 29th February, will I have any issues for the following years? Basically asking does Smartsheet recognize leap years? Thanks!