Peer Book Review & Rating
Hello,
In our business we read a lot of books and share the knowledge among ourselves. Therefore I am developing a "Peer Book Review" sheet whereby any employee can look up a book title and add their personal review comments and rating. If the book is not on the list already, they simply add it as a new book.
I created a sheet where the book title is the parent row, and the reviews are the child rows, but it seems like a clumsy data structure, and the number of reviews will vary by book so the user would have to add a child row everytime.
Is there a template for this already? I looked and couldn't seem to find anything similar.
Any help is appreciated. Thanks.
Answers
-
Instead of using parent children hierarchy's, use a report and group by book name. So every time someone fills out a form/review they add a new row, in the form there is a dropdown to select a book to review, or if you don't have the dropdown restricted they could also enter the title of a new book. You would have to update the dropdown though for future reviews of new books.
In the report if you group by book title it will keep all the reviews in their respective drop downs similar to parent child hierarchy.
**If you have "Advance" or data shuttle I believe you could use data shuttle to auto update the dropdowns.
-
Thanks Samuel - that's a great suggestion - much appreciated!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives