Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Team "Work in Progress" sheet?
Hi All,
We have a team of 5, and one manager overseeing their work.
Then we have 3x project sheets, with rows of tasks. When the team member starts working on the project task, they click a "work in progress" checkbox on that row.
The manager can view the 3 sheets individually and see when a team member is working, because the checkbox is ticked.
I am planning to make another sheet (Overview Sheet) which will link cells to the "work in progress" checkboxes. So the manager can see an overview across the 3 sheets of who is working on what. The problem is, sometimes we add new rows to the project sheets, and so we'd have to keep updating the new Overview sheet and it sounds like a lot of work.
Does anyone have any ideas on how we can see in real time, who is working on what task?
Hope that makes sense!
Thanks!
Comments
-
Use a Report to pull in items checked "work in progress".
See the functionality here:
http://help.smartsheet.com/customer/portal/articles/522214
Hope this helps
Craig
-
Perfect thanks very much Craig !
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives