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
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives