Battle over Sorting and Filters
Greetings,
We are starting to use Smartsheet heavily in a lot of our processes. We deal with contractors on a daily basis.
We have several groups of contractors that view one master sheet and each of their own set of columns they review and work with. They may not directly interact with other parts of the master sheet, but they sometimes require data from other columns to complete their job. It's very situational.
We have two different contractors that sort specific columns to make their jobs easier and their teams depend on the order of the sorting as they complete their jobs.
When Team A does their sorting and their team reviews the sheets we are running into issues as they are getting confused because Team B has went in and sorted the sheet to match their criteria so Team A's group is lost as they were following a list that is no longer in the order that it was when they first looked.
It becomes a tug of war over the sheet.
We are trying to avoid created 5 different mirror sheets as that sounds like a maintaining nightmare.
Any suggestions?
The contractors have to view their columns and then they complete their jobs and they updated the specific columns based on their completion.
Comments
-
Hi Sinema,
I'd recommend using Reports instead. They can then sort and see the columns that they need.
Would that work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 297 Events
- 33 Webinars
- 7.3K Forum Archives