-
Automation Condition Not working
Hey all, I set up an automation to request an update if one field is blank and if another field is not a specific list of departments and I got an email this from someone in that department saying they got an email anyways. Can you take a look at the below screenshots and tell me if I'm missing something? Here is the…
-
Retrieving Ancestor (date) value from multi-level parent-child rows
Hi All, I used the following formula to retrieve ancestor (first parent) date value of the multi-level parent-child rows for each row. =LEFT(INDEX(JOIN(ANCESTORS(Date@row), ","), 1), 8) The issue that I'm facing is the return value being "TEXT" despite having "DATE" column type. Since I have to use this return value in…
-
How can I log a timestamp of a cell change?
I want to add an automation rule to write a timestamp of when a cell value changes, I know I can use the "record a date" automation to get the date but is there any way I can get the exact timestamp similar to the "created at" field in form responses? I am also looking into a way to implement it using the API and there…
-
Auto-Revoke/Cancel Update Request
I have an [Assigned to] contacts column with multiple contacts per cell allowed. Based on certain criteria I have a workflow setup to send an "Update Request" to all of the contacts in [Assigned to]. However, I only require 1 (one) of the contacts to provide the requested update (as they chose based on their availability).…
-
Automated Email Reply After x Amount Of Days
I am looking for a way to set up a workflow so that once a box is checked, an automated email will get sent out to a person a few days later.
-
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,…
