How to pull a UID to a seperate sheet based on criteria?
Hello,
I have a form that feeds into a master list and auto-generates a UID. I'd like to pull all UID's for a team, as identified by the column "Program Alignment" within the master list, into a separate sheet for each team so that I can Data Mesh off of that UID.
Thanks for the help!
Steve
Answers
-
Possibly a Copy Row Automation with multiple condition paths based on each team.
If you have Data Shuttle you could also offload the master, then upload back to each individual team sheet
-
I think Copy Row Automation might be my answer but I'm getting the following error.
-
Make sure you don't have an auto number column on your destination sheet, even easier start with a blank fresh grid and let the first "Copy Row" execution add all your columns for you
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!