Reminder Automation Help

LFeliciano

I have a sheet with a column that contains about four choices. I need an automation to go out weekly until one of the choices is changed in the cell. The choice is like a complete status but named differetly. If any of the other three choices are selected in the cell the automated email should go out to the person who is named in another cell. I have the Trigger set to When rows are added or changed, is that right? I need help with the trigger and then the condition. I'm getting both mixed up. I feel like this should be fairly straight forward but can't figure it out. Any assistance would be appreciated. When condition is met, emails should stop going out.

Naeem Ejaz

You mentioned using "When rows are added or changed" — this is not ideal for a weekly reminder. Instead, use:

• Trigger: When a date is reached
• Frequency: Weekly (e.g., every Monday at 9 AM)

This ensures the automation runs every week, regardless of whether the sheet is edited.

Now, set up a condition to check the value of the Status column.

• Condition: If Status is not equal to "Complete"
• AND (optional): If the Assigned To column is not blank

This ensures the email only goes out if the task is still pending and someone is assigned.