Sign in to join the conversation:
I was trying to think of a way to have fun using smartsheet to host and create a football pool for my daughters dance team fundraiser. Does anyone have a template already or have any ideas on how to create this?
Can you describe how you would want this to work?
What would the process be for getting information into the system? What would the output be?
Creating one of these for the upcoming world cup would be a great promotional tool for Smartsheet.
Should be fairly easy to develop. Just need a sheet with a form that allows users to select the winning teams (or select draw) for each match. Once the matches are complete the form owner would input the winning teams and the form would automatically calculate the points for each participant. (e.g. 0 points for incorrect, 1 point for correct.) based on whether or not they got the correct answer.
Results would be provided via a read-only report that listed participants sorted by points and by name.
There would need to be a sheet (or form) for each round of the tournament.
This would be great fun within any organization. Thinking about building it myself but short on time these days.
Sorry it took me so long to get this out! You might enjoy this Smartsheet Christmas tree I created in Smartsheet. The Sheet Summary has a field ("Color Mode") that you can use to change the light colors :) I'm also attaching the excel file containing ALL the formulas you'll need to recreate it. SEE MY REPLY BELOW FOR THE…
I used the new feature with the dropdown column type where you can reference a single source sheet for dropdown values (thank you, Smartsheet!), but when I am creating my form, it doesn't show that field in the form —- see error message below. Has anybody experienced this and if so, what did you do?
How many words can you make from 'Smartsheet' using each letter it appears in the word?!? Ex: 2 'E's, 2 'T's, 2 'S's ✅
