-
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,…
-
Automation Trigger for 'no attachment found'
I have a form that is supposed to have an attachment when submitted. Users are filling it out without an attachment. I would like to trigger an email when a form is submitted without an attachment. Right now, the only option i can find for an attachment under trigger, is when there IS an attachment included. I also tried…
-
Established Automations Suddenly Failing
Thank you for taking time to read my question! We have been using Smartsheet for over a year. We have several automations (triggers) that are well-established and that have not been edited. These automations trigger rows to be copied to other sheets, which are a very important part of our workflow. Lately, and often, the…
-
Recurring Task Tracker
Good afternoon, I set up a recurring task tracker for use by different groups within my department but am having trouble setting up the recurrence for automation. I would like the automation to begin the 25th day of each month (irrelevant what day of week) and repeat for the next 21 calendar days. As I go through the…
-
Trigger "when rows are added or changed" doesn't work
Hello all, I have created a Workflow to send a weekly email notification when rows are added or changed in a Sheet, but it doesn't work with "Run Now". It doesn't detect any of the changes made. I have created this Workflow on other Workspaces and it works fine. If you have any idea, why in this case it is not working, do…
-
Automation - replace existing values in multi-select column?
Hi all! I have a question about an automation I'm trying to set up. We have an onboarding status dropdown column that people can check off as certain steps are completed, and I'm trying to automate so it's not so manual and time intensive. The automation is the following: when a date is reached for date field "SIV Date"…
-
Multiple triggers and entries for the same item, possible?
Hi, I have a team that wants a solution that I can't figure out. Any help would be greatly appreciated (even if its a round about way to a solution). Trade submits inspection via form - generates a document/report, and This triggers a notification to Contractor 1 and Contractor 2, so that they complete their independent…