As a student leader of your club or sports team, you’ll benefit from an order form template! If you’re in charge of collecting info such as t-shirt orders or cookie sales, this spreadsheet template will make your life easier by tracking user-entered data and automating key data.
Check out the order form template in our 3-minute video tutorial below:
In our spreadsheet template, the first 5 columns allow club members to enter in data such as their name, gender, shirt size, number of shirts, and whether or not they have paid. The last 4 columns are powered by formulas and offer you valuable information, such as payment notes, modified shirt sizes, and which coach should collect the money.
If a user enters an incorrect entry, the spreadsheet template informs you to double-check that entry – all thanks to the IFERROR function!
As you create this spreadsheet template, you will learn various important functions including IF, IFERROR, AND, and OR. For individual video tutorials on each of these functions, click below:
You can also retrieve our spreadsheet template by clicking here: Order Form Spreadsheet Template. The template is in read-only mode. To edit it, first create a copy of it on your Google drive.Â
If this template is useful to you, let us know in the Comments box below!
I’m really impressed with your writing skills and also with
the layout on your blog. Is this a paid theme or did you customize it yourself?
Anyway keep up the nice quality writing, it is rare to see
a nice blog like this one nowadays.
Thanks for your kind words! I chose a theme as the basic layout and added a customization option.