Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Excel 2013 - 2 Data Validation Column in Google Sheet Document

Excel 2013 - 2 Data Validation Column in Google Sheet Document

Excel 2013 - 2 Data Validation Column in Google Sheet Document

Skip - Per your request, here's a copy of my 2nd inquiry about adding 2nd Data Validation column in Google Sheet document. Thank you.
(Same Excel worksheet attached before upload to Google Sheets.)


Hello again. In an 'ideal' world is there a way of doing the following 1 or 2 things?

First, could there be a 2nd data validation column to the right of the 1st one that allows the user to input info provided that it's not the same info as the 1st DV? For example, let's say the 1st DV column contains different 'types' of hardware -- light bulbs -- instead of names. We would want the user to input in the 2nd DV the BRAND of light bulbs they purchased. Possible?

Second, several users will have access to this Google Sheet in GMail. In an 'ideal' world, is it possible for each user to only have access to the DV cell(s) next to their name?

I think these are 'pie in the sky ideas' for another day ... thumbsup2

RE: Excel 2013 - 2 Data Validation Column in Google Sheet Document


Please explain the purpose of this sheet.

Please upload a sample sheet, not necessarily functional, that displays the columns you need with an expaination for each column.

Functional data would be helpful in these examples.


glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close