Is there voting functionality within smartsheet?

Lauren T
Lauren T ✭✭
edited 12/09/19 in Smartsheet Basics

I'm looking to see if there is a way to vote within a row. We're doing a hackathon to collect ideas for future development which will go to a panel - we'd like the ability for multiple people to vote on a single item. Any suggestions or workarounds anyone has used in the past?

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Lauren,

    How many voters?

    Can you describe your process in more detail?

    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.

  • Lee Joramo
    Lee Joramo ✭✭✭✭✭✭

    If you are dealing with a limited number of people who you know in advance of the voting, you could assign each of them a column to vote on, and have the vote part of an approval workflow. I have done this for purchase approval processes that require the sign off of 6 department/team leaders.

    If your hackathon involves many people -- especially when you don't know who will be voting in advance, you will need to look to some sort of multi-sheet system with lookups connecting the sheets, and/or adding Reports.

    (Many of the brainstorming/planning meetings l have been involved in, have used the system of putting all of the "Ideas" on sheets of paper and giving the voters a limited number of sticker dots that they can stick next to the ideas they like. Spread their dots across ideas, or vote repeatedly on same idea. This would be cool to see implemented in smartsheet.)

     

     

  • Alejandra
    Alejandra Employee
    edited 06/27/19

    Hi Lauren,

    There isn't a built in voting feature within Smartsheet, but this would be great opportunity to submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    edited 04/10/19

    You could also set up a form for each item with a rating or voting column whether it be 5 Stars or a dropdown of "Yes" or "No" or something to that affect. You could create a sheet that lists all of the items people can vote on along with a hyperlink that takes them directly to the form.

     

    Each form entry will create it's own row in a Master Sheet. You can use default values to establish an identifier for each item's form submission.

     

    Since every vote would be on one Master Sheet, you could very easily pull metrics and get your totals from votes. I have used this setup before, and it worked very well for me.

     

    I created one form for Item A and called it "Item A Vote". It had a description of the item in the Help Text and I used a 5 start rating. I then used a hidden field with a default value of "A".

     

    Then I simply duplicated the form, changed a little bit to reflect Item B, saved that, duplicated and adjusted for C, so on and so forth.

     

    When I created my listing sheet, I would use a Category as a Parent row and then list all appropriate items as children. I would use the Hyperlink function and change the Display text to the item name, and have a brief description in the cell next to it.

     

    I also set up each form to take the user to a specific URL after they submitted and used the URL for the Listing Sheet.

     

    I hope all of my rambling makes sense. Here's some pictures... Haha

    Comm1.PNG

    Comm2.PNG

    Comm3.PNG

    Comm4.PNG

    Comm5.PNG

    Comm6.PNG