5. Use Data Validation to Set Status and Task Owners
In this video, you will use data validation to assign task owners and track the statusof each task. Data validation enables you to create a drop-downlist of possible choices within a cell. Limiting choices to a list saves time and reduces thepossibility of errors when organizing your club.
As your group organizes a club, you will use the drop-down list to track each task andview whether it has been started, is in progress, or is finished. You will also use a drop-downlist to assign who is responsible for completing tasks.
To begin, select one group member to add data validation to the status column.
Next, type the text that you want to use to describe the different stages of your project.
Now, use the drop-down list to change the status of tasks. The data validation actsas a checklist to ensure each task is completed on time and nothing is forgotten.
As your group continues to organize your club, update the status of each task.
Data validation can also be used when assigning task owners. The owner is the person responsiblefor completing each task. Use data validation again, this time listingeach group member’s name. Add “All” to the list of names for tasks that everyonewill work on, such as brainstorming your club’s topic.
Use the drop-down list to assign an owner to each task.
Now, it’s your turn: Use data validation to update the status ofeach task. And use data validation to assign an ownerto each task.