-
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!
-
define user
Hello, I have a specific cell. When a value is entered into this cell, the person who entered the value should fill out a form from another sheet. I've tried to implement this through a workflow, however, in my sheet are many editor columns as there are different roles in a row, so it's not possible to define who should…