Skip to content

GS Challenge 6 – Data Validation

Welcome to the sixth Spreadsheet Life Google Sheets Challenge. I will ask four questions to test your data validation skills within Google Sheets.

I highly encourage you to download a copy of this spreadsheet using the link below. That way, you can attempt each question before viewing the solution.

Google Sheets Challenge 6 – Download a Copy

Now if you’re ready to test your data validation skills in Google Sheets, then let’s get to it.

Question 1

Your task for question 1 is to add data validation so that the user may only enter valid date values in the start date field.

Question 1 – Solution

To solve question 1, begin by selecting the range C4:C13. Next, go to Data Data Validation.

In the panel on the right, change the ‘Criteria’ to is valid date. Then, select reject the input under ‘if the date is invalid.’

You can then click on Done. And that completes question number one.

Question 2

For question 2, your goal is to add data validation to ensure that each email address entered by the user is valid.

Question 2 – Solution

To solve question 2, start by selecting the range D4:D13. Next, go to Data Data Validation.

In the panel on the right, change the ‘Criteria’ to is valid email. Then, select reject the input under ‘if the date is invalid.’

You can then click on Done. And that completes question number two.

Question 3

For question 3, your task is to create a dropdown menu for assigning available roles to each employee.

Question 3 – Solution

To solve question 3, begin by selecting the range C4:C13. Then, go to Data Data Validation.

In the panel on the right, change the ‘Criteria’ to dropdown (from a range).

Click on the select data range button, and select the range E4:E9. You can then click on Ok and then Done.

And that completes question number three.

Question 4

For question 4, your goal is to add data validation below to mimic the formatting and dropdown menu you see on the right.

Question 4 – Solution

To solve question 4, select any cell in the range H4:H13. Then, go to Data Data Validation.

In the panel on the right, select the existing rule.

Under ‘apply to range,’ click on the select data range button.

Click on add another range, and select the range C4:C13. You can then click on Ok.

Finally, you can click on Done. And that officially completes question number four.

How Did You Do?

Tell me – how did you do? Let me know in the comments below if you found these questions to be pretty easy or rather challenging.

I’d love to hear your thoughts!

Also, if you missed any of the other Google Sheets challenges, you can find the first three listed below.

Watch the Video

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top