How can I have a specific row only run at 7:00 AM every day?

You can’t schedule a specific row to run at 7:00 AM every day—scheduling is set at the source or column level, not per row. However, you can use conditional runs to limit which rows are processed during a scheduled run.

To do this:

Example:

If you want only rows where a column equals “Active,” use a formula like column_name = "Active" in the “Only run if” box. This ensures only those rows are processed daily at 7:00 AM [4].

Did that answer your question?

Could I say only run if this row has "Transcript found" and then tell it to only run at 7:00 AM?

Yes, you can set up a scheduled run to only process rows with "Transcript found" and have it run at 7:00 AM every day.

Here’s how:

This will ensure only rows matching your condition are processed daily at 7:00 AM. [1] [2] [3]

Did that answer your question?

Should this work

Yes, your formula should work if you set it up correctly. In the “Only run if” box, enter a formula like Transcript found = "Transcript found" (replace with your actual column name). This will ensure only rows with “Transcript found” are processed during your scheduled run at 7:00 AM. You can use the “Use AI” button to help generate the formula if you’re unsure about the syntax. Just make sure the column name matches exactly as it appears in your table. [1] [2] [3]

Did that answer your question?

Now?

Your formula should work if it’s set up correctly in the “Only run if” box. You can combine conditions for “WH Lifecycle Stage” and check for “Transcript found” using logical operators like AND or OR. However, Clay’s conditional runs don’t natively support time-based conditions (like running only at 7:00 AM) within the formula itself—timing is handled by the schedule, not the formula. So, make sure your schedule is set to run daily at 7:00 AM, and your formula controls which rows are processed at that time. The formula will only run the enrichment for rows that meet your specified criteria, but the timing is managed by the schedule, not the formula’s logic [1] [2] [3] .

Is that what you were looking for?

Perfect! Your setup looks correct. You have:

The conditional formula you showed earlier will control which specific rows get processed during each scheduled run. Only rows meeting your "Transcript found" and lifecycle stage conditions will actually run when the schedule triggers at 7:00 AM. [1] [2]

This setup should work exactly as you want - daily runs at 7:00 AM, but only processing the rows that match your criteria. [3]

Is that what you were looking for?

If you need any more help with setting up your scheduled runs or formulas, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any issues you’re encountering?