Why does the entire sheet copy instead of just row?
I have set up an aumoted work flow- so that only rows check for at risk will get copied into another sheet. Instead the entire sheet is getting copied there. How do i restrict to rows only?
Answers
-
Hi @Z_L
Can you post a screenshot of your workflow?
-
Hi @Z_L , I'm wondering if this is a level/hierarchy issue for you…
do you have parent level rows that are getting the "at risk" column checked and therefore the automation is copying that row (and all its children rows)? I have not tested this, but perhaps if that is the case, you could have a level column…use the formula =COUNT(ANSCESTOR()) for this…and then have that help you filter out the parent rows if you don't need them in your second target sheet.
Let me know if further clarification needed…or if this doesn't work for some reason.
Good luck!
Will
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives