Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialGabriel Guerra
Data Analysis Techdegree Graduate 9,109 PointsData Validation displayed differently
Hi there, My data validation menu on google sheets is displayed differently and it doesn't include all the functions from the video. It doesn't let me attach a screenshot here, but the menu is on the right-hand side and no pop-up is being shown after clicking on "data validation". Does anyone know why? Thanks, Gabriel
1 Answer
Heather Crummer
13,558 PointsHi Gabriel. I agree, it's a little confusing because Google Sheets has been updated since the video. You can still validate the data in the same way as the video, but the wording is a little different.
- For the Quarter 3 entries: Instead of selecting "Number" and then selecting the range, you can go directly to selecting "Is between" and it will automatically assume you mean Number by the data in the cells.
- For the missing pop-up, did you mean when you were supposed to select "Appearance: Show validation help text" and then enter an incorrect value for Arizona in July in cell J4? If so, that has been changed to "Show help text for a selected cell." If you click on that, you should get the pop-up when you enter a value outside the range.
- For the New Cell Suggestion List: "List from a range" is now "Dropdown from a range."
Hope this helps!
Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 PointsGabriel Guerra
Data Analysis Techdegree Graduate 9,109 PointsThanks :)