Punch List vs Room-Ready Reporting
Hi All,
I've been wracking my brain on this and can't come up with a solution. Please help!
Current Use Case: Users (without SS accounts) use a form to fill in punch list items for rooms they are checking out. We need a separate punch list for each project to share with the builder in a public link. The punch list needs to be automatically generated via Control Center when the project manager checks a box in their separate project sheet. The punch list has several formulas based on check boxes to determine the status of the item. Some of these fields are locked so only the QA team can check them off.
The Problem: We are being asked to provide a room-ready list to show rooms that have open punch list items vs total number of rooms in scope. Each room may have more than one punch list item, or none at all.
Current Thoughts: I could add a checkbox in the form that says something like "No items to report for this room". That would at least give us all the rooms that were checked in one list. I can't think of a way to check the list of rooms in the punch list against a full list of rooms without having to enter a formula for a cross-sheet reference after the sheet has been generated. The idea here is that everything should be automated. I thought about pulling a report on all rooms checked, but then I can't use a formula to compare complete vs incomplete. I also thought about Dynamic View, but then I don't see a way to enter new lines, and it's not as user-friendly as the form.
Any help is greatly appreciated!
Answers
-
Are you able to provide some screenshots for context?
-
Unfortunately not, because of company compliance rules.
-
What about a mockup with sample data? It's tough to follow the overall architecture as well as the structure of your sheets.
-
Here's kind of what we're working with now:
-
Hi,
I hope you're well and safe!
What about using the URL-Query feature to ID the form(s) to the right project?
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
-
IDing the projects isn't a problem; each project has a separate punch list sheet. The issue is comparing the rooms with open items in the punch list to a full room list to show room-readiness.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives