Raffle Type System in a Smartsheet Form

I am looking at trying to build a multi-select option raffle form. Lets say a form user has 5 options or "tickets" they can put into a bucket of goods for a raffle. I would like for the user to put in any combination of entering tickets per good that they can with the five tickets they have.

I will put in a picture of what I mean below.

Lets say I get give tickets and I decide I want to put 2 in bucket 1, 2 in bucket 3, and 1 in bucket 5.

Is that possible to do in a form? Basically set a number limit of "tickets" they can distribute between "buckets".

Happy to elaborate more. Thanks.

Find more posts tagged with

Forms

Sheets

Formulas

Accepted answers

All comments

marc4

In the form you can have each ticket a column and have each column a drop down with each bucket listed.

Are you looking to have the number of tickets change per person?

/marc

Ty Werven

No, every person will get the same amount of tickets

That’s a good idea. I was wondering if there might be any faster options, though, since a big goal is making it easy for people to fill out and ensuring the data is captured in a way that makes it easy to randomize a winner, if that makes sense.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.