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…
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 b…
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…
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?
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 t…
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 depende…
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 indicatio…
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 man…
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 Febru…