-
Merged: Copy cell value(s) to another one if value/specific value is input in a specific cell
This discussion has been merged.
-
Limitations with the custom message sent to the same user - Maximum repetitions allowed is only 6nos
The screenshots here shows the two scenarios that a recipient receives when a workflow is triggered from the Smartsheets Scenarios-1: The body message is not shown to the recipient if their name repeats more than 6 times/row items in the Smartsheet Grid. Scenario-2: The body message is shown to the recipient if their name…
-
Dont trigger workflow on specific dates
Hello Community, im building a tool in which we input data from the last day every day. So i have a form in which workers are filling information about the yesterday shift. On Friday they are filling in it for thursday and on monday they are filling in the information of last friday. (And so on) The information is then…
-
Ability to exclude a single column from an Automation Trigger
We have an automation that triggers when any field is added or changed and sends updates. However, we have a field that calculates the aging of each line item. We would like to exclude this single field from the trigger. Currently, our only option is to select all of the columns you DO want to be included, but not ones to…
-
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"…
