Why does my workflow automation send all rows instead of just the changed one?
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!
Best Answers
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
No problem! 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
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.
-
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?
-
@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
-
ok thank you!
-
@Genevieve P any chance you know why this is happening?
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you @Genevieve P
-
No problem! 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives