-
Automation Assistance
Good morning Community! I have created a sheet to keep track of all company board meetings. Each department is responsible for submitting material (attachments) prior to the meeting and automations are to be put in place to remind board members of the deadline to submit. The issue I'm having is, how can I have each…
-
Reminder Automation - Help Needed
Am I overthinking this? I have a sheet set up to send out a notification when someone is assigned to a row. I am looking to also send a follow up reminder after 5 days if the assignee has not taken any action. However, both the notification automated email and the reminder automated email are sending at the same time. Any…
-
Do users have to login to receive notification emails as an automated workflow from a sheet?
I have an author schedule for a weekly blog that I would like to use to send out an automated reminder email to the assigned author each week. They don't need to go into the sheet to update anything, it's just for me to track. We are in the process of creating SS accounts for each author but I want to make sure I'm giving…
-
Automation-Date in the past
I have a column named "Shipping Date" and then, a second column with a formula that gives us a date 5 weeks prior to that "Shipping Date". This second column triggers and automation to contact the customer once the date is reached. What if the line is entered and the 5-week gap is a date in the past? How should our…
-
HOURLY reminder function
Hi everyone, I've been looking through dozens of post in the last couple of days to gain some insight on how to set up HOURLY reminders based on a status of a column not changing. I have not been able to figure this out as most of the references I am seeing are about Daily reminders and fields that have Dates in them. Here…
-
Automated messages send rows filled with dark color
Hello, I am having an issue with automated messages. The issue is the rows I selected to send are coming in via email with the background filled in a very dark color. It is very hard to read and will likely be ignored by users. It is happening when using several automations. However, here is an example of the most recent.
-
Automated Reminder Status Linking
I am wondering if it is possible to link automated reminders to my status colors on my Gantt chart. For example, if an item is completed, it turns green; if it is due in 7 days, it turns yellow; and if it is due on the day or is overdue, it turns red. And if it is overdue, then it wont sent out the reminder.
-
Reminders and Notification format
Hello, I have an automation to send weekly notifications of the status of projects to the person assigned to the project. I noticed that the email received creates a message per row and not just one message with the summary table at the end. I have the same automation on other sheets and the format is correct. Is there…
-
Row Reminder Email with Link
It would be much more convenient if there was a link to the sheet in the email received from a Row Reminder, like there is from an Automation email.
-
All permissions and triggers set correctly, yet I'm not receiving reminder emails
Hello, I have two sheets (Reminders and Shipment) in my account and both have workflows that run reminders, however, I don't get the reminder emails from the Shipment sheet. When I run the reminder workflow using the "Run Now" function, I get the email but when I run it through the trigger, I don't get the email. Find…