| A | B | C | D | |
|---|---|---|---|---|
1 | Spreadsheet for team collab feedback & voting | |||
2 | I wanted a sheet so I could allow people to collaborate by submitting their personal feedback about a new product we are trying out. To prevent duplicate responses, I added a voting system where others with the same feedback could agree with previous submissions. I had to write a new function code in appsscript called vote5, vote6, vote7 etc and apply each code to each agree button. If anyone has use for this document I wanted to share it so you can save yourself time and effort! | |||
3 | Here is the web app for the appscript code: https://script.google.com/macros/s/AKfycbxE1mL5VKeEGosfS74yzzK2g1WZ6aOj2kdamcwkrIynVPAq38Q/exec | |||
4 | Click once to tally your vote | You/your employee's feedback or suggestions | Number of Votes: | Submission Owner: |
5 | ||||
6 | AGREE | |||
7 | ||||
8 | ||||
9 | ||||
10 | ||||
11 | ||||
12 | ||||
13 | ||||
14 | ||||
15 | ||||
16 | ||||
17 | ||||
18 | ||||
19 | ||||
20 | ||||
21 | ||||
22 | ||||
23 | ||||
24 | ||||
25 | ||||
26 | ||||
27 | ||||
28 | ||||
29 | ||||
30 | ||||