-
Anyone experiencing automations not working?
I have 20 automations all set up the exact same way to copy a row. Out of these, 5 of them stopped working when a row is added (how they are set up) or won't work when I manually attempt to trigger them. When I do the manual; for the entire sheet or a specific row, it says that it ran successfully but doesn't update the…
-
Automated Workflow Not Triggering as Expected in Delegate Sheet
I have two different sheets, and I'm facing an issue with automation triggers not behaving consistently. The Main Sheet contains all data and approvals. I set up an automated workflow to send reminders every second day to approvers who haven't checked their assigned tasks. This works perfectly without manual intervention.…
-
Date Range in Date Column + Automation
Hello! I have an automation that currently sends users alerts based on the date in a column called "End Date". A majority of the time, the end date is a single date. However, sometimes the end date can be two or more days (ie- May 7th-8th). While I can write into the date column ="May 7th-8th", that will prevent my…
-
How can I
I'm trying to find a way of updating the column Term Expiration Date with the New Term Date column. I currently have a workflow that once a date is entered into the New Term Date it copies that row to a new sheet. The problem that I am running into is if I use the Data Mesh, or Data Shuffle it tends to update…
-
Alert Automation: Links are not working on our Client's Email but working on others
Hi All, Our problem is not being able to click the Hyperlink we attached to our Automated Alerts. When we test it out on our side, it works. It also works for external emails/personal emails. My initial conclusion is this could be a security issue on their outlook. But I would like to know if anyone experienced this before…
-
Add Attachments while filing a form
I have a Smartsheet form that my team uses for auditing processes. Is there a way to have a "Upload an attachment" option into the form?
-
Dropdown list
Hello! I have a Smartsheet document with columns that have dropdown lists. When I enter a value into one of these columns that is not already available in the dropdown list, I want that value to be automatically added to the dropdown list without having to manually edit the list. Is there a way to set this up so that new…
-
Duplicate Alerts
Hello! We have a sheet that is sending 2 update requests each week to each recipient. It's a very simple automation and the update history only shows one notification going out. Does anyone have any idea what could be going on? Thanks in advance for your help!
-
Automation / VLOOKUP help
Hello! My initial gripe comes from wanting to copy only certain cells from a row into another sheet. I've read a bunch of the threads for create a helper sheet, add dummy columns, and then use VLOOKUP, but I just cannot get it to work for myself and I'm uncertain what I'm missing! I have Sheet A that contains all my raw…
-
Automation: Sender issue
I have 3 coordinators working from the same sheet. Their case load is determined by last names, A-L and M-Z for the 2 coordinators and a specific program assigned to the 3rd coordinator. Anyhow, the delimea we are having is that when the automation for assignments go ount on trigger, it appears that it is coming from the…