Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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?
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
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.)
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.
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
Is there a way to revert to the old dashboard look and feel. The new dashboards do not look good at all. There is no way of knowing if there are additional items in the widgets until you scroll over one to learn there is more to it since the vertical bar doesn't show. We have hundreds of dashboards and they will all need…
When i try to send or print the timeline view instead of showing the progression bars like they do on the screen it only send the data entered and not a graph type view to print. Is there a way to do this. I am using a mac platform if that helps.
I have reproduced the following behavior in a validated Smartsheet application. User permission: Editor (not Admin) Row status: Locked (confirmed via row menu displaying "Unlock Row") Text, Date, Contact List, and Checkbox columns cannot be modified. Dropdown List columns remain editable. Selecting a new dropdown value and…
