Change a cell automation flow changes all cells in the selected column
I have created a change cell workflow - When Madison is assigned, I want the progress tracker to change to Action Item. When I trigger the automation flow, all cells in the progress tracker column are changed to Action Item. Not just for those rows where Madison is assigned. It does the same for other change cell automation flows I created. What am I missing?
Answers
-
Try changing the trigger to when In Queue With - WIP changes, and moving the condition of 'Madison' listed in your trigger to a condition block before the Action block.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thanks Jeff,
I just realized I missed something, as I was digging back into it your reply arrived. I did add the condition and that did the trick.
Have a great Holiday. Thanks for your help.
KR,
Gras
-
A quick note about running workflows manually... They ignore triggers and only look at conditions. That's why when you ran it manually it hit every row until you added the condition. If left to run based on trigger alone, it should have worked. It was just that manual run that did it.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives