Why does my workflow automation send all rows instead of just the changed one?

Kelly S

Hi

I am using a simple "To Do" sheet and want to be alerted when a row is due tomorrow and the owner has not flagged the item as completed. I've show below what I tried setting up but it sends them ALL rows in the sheet. I just want the applicable rows sent. Thank you!

Genevieve P.

Hi @Kelly S

It looks like all rows are being sent because of how you have your trigger set up - you're running it Every Day, instead of running it based on the Date Column...

Try adjusting these two things: what date it's looking at (basing it off of your due date column), and the frequency of the trigger (having it run 1 day before the date the in that due date column):

You can read more information on setting date-based triggers in our Help Center (see here).

Let me know if this works, or if you have other questions!

Cheers,

Genevieve

Genevieve P.

No problem! 🙂

Robert Gochee

Kelly,

I assume that the Status Column is a Drop Down List. Have you tried using the Condition Where the "Status" option is "Is One Of", something similar to below.

Kelly S

Hi @Robert Gochee , yes, the Status column is a drop down. I'm not sure I understand how your Condition on the Status Column would make the outcome different than mine?

rgochee

@Kelly S ,

This is just my preference is setting up the workflow, by using the "Is One Of" or "Not One Of' with drop downs and thought I would suggest.

Rob

Kelly S

ok thank you!

Kelly S

@Genevieve P any chance you know why this is happening?

Genevieve P.

Hi @Kelly S

It looks like all rows are being sent because of how you have your trigger set up - you're running it Every Day, instead of running it based on the Date Column...

Try adjusting these two things: what date it's looking at (basing it off of your due date column), and the frequency of the trigger (having it run 1 day before the date the in that due date column):

You can read more information on setting date-based triggers in our Help Center (see here).

Let me know if this works, or if you have other questions!

Cheers,

Genevieve

Kelly S

Thank you @Genevieve P

Genevieve P.

No problem! 🙂