How to Control the Values entered into a Google Spreadsheet

Collaboration in Google Docs is by far one of our favorite features. But we’ve noticed that one issue arises when people are collaborating in Spreadsheets. Sometimes you want to limit what people can input into a field, to make data collection easier.

Data validation helps you control what data you and your collaborators enter in your spreadsheets. Here’s what you can do with data validation:

1.) Validate numbers, dates, and text.
2.) Prevent users from entering text that doesn’t match your criteria, or show them a comment on the cell when the data doesn’t match the validation rule.
3.) Add text to the cells you add validation to, to help your collaborators enter the right type of data.

Comments (4) Write a comment

  1. Does this work on spreadsheets that are linked to a form?

    Other way… can i use this data validation in a cell shown in form, such a when there text field on the form where i want people add only dates?

    Thanks!!

    Reply

    • Carlos,

      I don’t believe so. That integration would most likely need to be an option inside the actual form, not the responses Spreadsheet.

      I’d love to see it added though!

      Reply

  2. Dear Sir,

    I am using data validation feature in 1 cell such that it shows me a list from the values of two other cells in the same row. i.e Cell C2 will give me list of values from cell A2 and B2.
    Sheet1!A2:B2

    This is as i want it to be.

    Now I want to the same to whole column. i.e. I want to copy and apply the same kind of validation to Column C, so (after applying the validation) the validation in cell C9 will be from cell A9 and B9
    Sheet1!A9:B9
    and similarly the validation in cell C15 will be from cell A15 and B15
    Sheet1!A15:B15
    and so on

    so if the cell is Cx the the validation should have
    Sheet1!Ax:Bx

    I want to this Auto and by not setting this for each cell manually.

    I tried to assign the validation to two cells and then selecting the both and dragging from the corner to the whole column so as to auto fill in progression as in excel but it just repeats in pattern of the specific 2 cells.

    I hope you Understood me.

    Thanks for taking time to read through.

    Regards,
    Anurag

    Reply

Leave a Reply

Required fields are marked *.