Create a checklist report to document end user review of records
I'm not sure how to tackle this one, all suggestions are welcome (thanks in advance).
A project manager has 50 projects. They want to document that they have reviewed all project activities (tasks, reports, etc) monthly. So they are asking for a basic list of active projects assigned to them and an easy way to mark complete (checkbox) that also shows history.
So my initial thought is a list of active projects assigned to this person (easy enough) but I'm not sure what to do about the date (history) such that it doesn't require monthly maintenance to insert a new row/column of checkboxes or to duplicate the active project list.
Thanks!
Comments
-
What if you made a checkbox column for each month of the year on the same sheet as their list of projects. That way they could could mark off that they reviewed those each month and you could set up all 12 columns in minutes.
-
Hi Mike,
One way to do it could be to have a checkbox column that they check of and then you reset the checkbox until next time and then you can see all the history in cell history.
Would that work?
Have a fantastic day!
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.
-
Thank you both for your suggestions. What I decided to do was create a sheet in each project (to be setup when a new project starts). I manually create a row for each month when review is required. The I made a report for the project manager's dashboard to search for these sheets in the workspace only returning rows that have dates before today (sorted in descending order.) This eliminates future review dates before they occur. It is still less automated then I want it to be but I think it will work for now. Thanks again. I was drawing a blank and couldn't make any progress, but when I read your replies it really helped me to move forward.
-
Great!
I'm always happy to help!
Best,
Andrée
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.
-
I'm glad we were able to help out!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives