How to trigger email alerts based on a single due date across multiple rows?

ryanjaz

I'm trying to figure out a more efficient way to handle due date notifications for Smartsheets automation. Here's my situation:

I have a template sheet that will be reused multiple times, each instance needing different due dates. When the due date triggers, it emails every recipient on the smartsheet. While I could set static dates in the automation tab, that won't work since this is meant to be a template.

Currently, my workaround is to create a dates column and manually enter the same due date for each row to trigger email notifications. I have multiple questions listed by category, and I'd rather not create an extra column just to repeat the same date value.

Is there a way to set one due date cell that would trigger emails for all recipients without having to duplicate the date across multiple cells?

Naeem Ejaz

Smartsheet automation rules are row-based, and date-based triggers must reference a cell in each row (e.g., “When [Due Date] is today”).

So even if the due date is the same across all rows, it has to be present in each row to work as a trigger — unless we rework the trigger strategy.