-
How do I set up an automation to send emails triggered by date/time instead of a Smartsheet change?
I've been able to successfully set up an automation workflow to send notification emails triggered by a change in rows on the Smartsheet, but is there a way to make the trigger a time of day? I've set up an automation workflow to try and send daily reminder emails at a certain time every day, but it's not working (see…
-
How to add time or subtract time from a date when "check" is selected?
Hi! Looking to see if this is possible. I have a packaging release date column that current pulls from another sheet for all items. I have items for Disney that I need to subtract 30 days when I click Disney checkbox column. When I uncheck the checkbox column, I want the date to revert back or add 30 days back. Here is the…
-
Copy of Template loses Alert Someone Email address in Automation
Hello, When I "Use" a template to create a new sheet, most of the automation remains, but the email address in the 'Alert someone' section gets erased and the Automation 'Saved Workflows' say UNABLE TO RUN. How can I get the template to keep the Automation workflows intact when I use the template to create a copy? I…
-
Automation on columns
I would like to set up a notification automation for when all the criteria in the column is met. For example, I have a column that includes a checkbox with the column labeled "complete". I want to receive a notification when the last checkbox in the column is checked, so that I know that all tasks have been completed on…
-
Issue with text parsing on date/time populated by automation
I'm having an issue where I have a created date column, then a date column that referenced the created date column and uses text parsing to remove the time. formula below: =DATE(VALUE(20 + MID([Issue Opened Date]@row, 7, 2)), VALUE(LEFT([Issue Opened Date]@row, 2)), VALUE(MID([Issue Opened Date]@row, 4, 2))) This functions…
-
How to change Automation Trigger from "Changes:" to "Changes To:"
Hello Community, I have set up a sheet and a form. The form has various drop-downs asking different fellows for their unique identity numbers. I am trying to copy the rows to the fellow's specific sheet when the drop-down is their unique identifier number. I am setting it up for 20 fellow drop downs, out of these the 19…
-
Conditional copying of rows from one sheet to another
I am building an inspection sheet and form where our operations team will be able to mark pass/fail through a checklist. If something "fails", I want that specific row in the inspection sheet to be copied over to another project tracking sheet. These two sheets will necessitate different fields. Upon the specified…
-
Counting days of ticket open but starting at 0?
I asked this question before and got a solution but now it is counting starting at 1 instead of 0. this is the formula used =IF([Date Closed]@row = "", NETWORKDAYS([Date Opened]@row, TODAY(0)), NETWORKDAYS([Date Opened]@row, [Date Closed]@row)) I tired using (today -1) but then it starts at -2. The date closed is an…
-
Option to not allow demo users to request access to subscription
Currently after a potential user is at the end of their 30 days, they are prompted to request a license. This is sent to the admins of our tool. This email trigger causes us extra work as we have to manage and respond to all these users to proceed with our software request process established by our company. Additionally…
-
Daily Update Solution without the need to open the sheet, use Zapier, or similar
Hi everyone, Happy New Year! I hope you're well and safe! I've developed a way to use the newly released Record a date feature to update sheets with today's date automatically without the need to open it or similar. 1. Add a so-called helper column. (Date). We can call it Today Helper and add a date before the current day.…
