-
Send Automation requesting update until conditions are met
I would prefer for it to send a notification until the conditions are met starting on a Wednesday at 9AM and only stop once a date that falls within that week in the Update Date field is applied. Is it possible to set up a condition that way? I set up the following workflow and when I ran it for testing I didn't appear to…
-
Can you setup an automation that pulls from an "email address" column that's not a contact column?
While I was at Engage 2023, I attended the Advanced Automations session where it looked like I'd be able to setup an automation that would pull from an "email address" column to send out automated emails. The example used in the session was having the Smartsheet automation setup to send an email to a customer (who was not…
-
Automated Update Request depending on how old the data is
Hi there I'm baffled - this sounds like a standard process but I can't work out how to do it and would appreciate any advice. I have a database, the first item in column one is "UPDATE DATE". I want to use this to trigger an update request - ie: if the date is older than 3 months, send an update request, and keep doing so…
-
Why can't I use automations on RYG ball columns?
Hi, Does anyone know why we can't use automations to change the cell value in symbol columns, like the RYG balls? It doesn't make sense to me that it's available for dropdowns but not for these. I do realize I could use a formula here, but that is not what I am looking for. I am looking for the specific capabilities of the…
-
Reports on Automations and Published Assets
From an Admin perspective, has anyone found a way to report on these concepts (globally, even if you are not the admin/owner of the sheets) Recipients of Automation alerts who are outside of your domain Lists of automations that will fail unless something is rectified Master list of Automations, their type / outcome,…
-
Automation is running but rows are not being copied onto corresponding sheet...
Hello, I have created an automation that will send a notification email and copy rows into another sheet when a box is checked to indicate that a cost center needs to be charged. In several tests of the automation, the emails were received but nothing has been copied over. I have double checked that the correct sheet is…
-
Send to Contacts in a cell VS Send to Specific People
I created a form and want mulpile people to be able to submit a request. Once the request is approved I want the person that send the request to recieved the notification that is was approved. The only option that I see is " Send to Contacts in a Cell" and "Send to Specific People". I don't want everyone that submitted the…
-
Auto Generated Number formula based on value in another column
I need help with a formula: Need auto-generated number based on: If value in "type" column is "Type1", auto-generate number in column "number" , otherwise, leave blank Cannot use Auto-Generate number column because of criteria Can make column formula to ensure auto-generated number is in new and existing rows
-
Dynamic view and Automation
Forgive me if this has been asked/answered before, but I cannot find anything helpful and Support was not at all helpful. Can I use Dynamic Views in combination with conditional logic in Automations? For example, is a user has a dynamic view that shows 20 rows of data, but there is an automation that I want to run…
-
How do I fix this workflow delivery error?
Hello, I have been receiving numerous emails about Workflow Delivery Alerts which say that some of the email addresses inside cells are currently not being notified and if I want them to receive notifications, either A) share the sheet with them or B) change my automation permissions. It only relates to automations where…
