Or you might require the user to input a valid date that is in the future. For example, in a “Status” column, you might allow for four values that appear in a dropdown: Not started, In progress, Submitted for review, and Done. Data Validationĭata validation sets rules about what values a cell will accept. In my virtual office, the combination of these handy selectors and color codes has transformed our data management system from a circus to a menagerie. That’s where data validation and color coding come in – two less obvious and underappreciated features of Google Spreadsheets. Whether you’re using Google Spreadsheets to track sales, manage an editorial schedule, or work with form data, sometimes it would be easier if there were some ground rules in the data set, if you know what I mean. Who added that column? You’re supposed to type a numeral, not the word “four.” Wait, Bob! 11 wasn’t an option! This is a 1-10 operation we’re talking about. Still, when it comes to more complex projects, things can start to swerve out of control. In the last several years, Google Drive has made working with teams on a set of documents or spreadsheets so much easier.
0 Comments
Leave a Reply. |