3

You could make the second validation list an if/then statement dependent on the answer to the first one. =if(A1="Movies","Horror","Baseball") =if(A1="Movies","Romance","Basketball") An example is here.


2

You have not mentioned what you would like to so with the three values mentioned, but maybe try: =index(B:BB,match(max(A1:A10),A:A,0)) or perhaps: =index(B:B,match(max(A1:A10),A:A,0))&index(C:C,match(max(A1:A10),A:A,0))&index(E:E,match(max(A1:A10),A:A,0)) or perhaps: =index(query(A:E,"select B,C,E"),match(max(A1:A10),A:A,0))


2

Please try a Custom formula is of : =weekday(A1)=2 to the relevant column (ie adjust A to suit).


1

I have a cell with a check box. I want another cell which contains a date to go green when the tick box is checked. You go to Format, Conditional Formatting and use the Custom formula: =COUNTIF($D3, "=TRUE") EXTRA: On the other hand, if you want the whole range/column to be highlighted use the following formula: =COUNTIF($B$3, "=TRUE") Pay ...


1

Yes you can, just un-check the "Show dropdown list in cell" checkbox on the data validation dialog.


1

In contrary to Short text, paragraph and checkbox questions, Google Forms doesn't have a way to validate input through date questions. Ref. Set rules for your form There is no way to add client-side code to the respondent view of Google Forms but you could create a web form that submit form data to the Google Form back-end. Some "early" approaches copy the ...


1

This used not to be possible, and I suspect still isn't. A workaround of sorts may be to enter: ={A3:A14;A19:A23} in a spare area, and then apply whatever range that occupies to the list range for your dropdown.


1

Overview From Extend Google Docs, Sheets, and Forms with Apps Script - Docs editors Help If you’d like to learn Apps Script but you’re new to programming, Codecademy offers a great online JavaScript course for beginners. (Note that this course was not developed by and is not associated with Google.) Once you feel like you have a handle on ...


1

Use =vlookup. Say your names are in ColumnA of Sheet1, with corresponding details in ColumnsB:C. In a different sheet ColumnD (assumed to be where the validation takes place) with names can be matched with the corresponding details with a formula such as: =VLOOKUP($D1,Sheet1!$A:$C,2,false) copied across to the right (with 2 there changed to 3) and then ...


1

Yes, with data validation: Eg Select ColumnB of Kids, Data (top right in image), Validation..., Cell range: Kids!B:B, Critera: List from a range Parents!A:A, select from options, Save. This should fill the range with the grey down arrows and when clicking one of these a dropdown list such as that shown should appear. If you were able to separate the ...


1

Data validation drop drowns in Google Sheets can't pull data from two columns. One solution is the one that you already figured out, join the values of those columns and the use those joined values.


1

Custom formula type of data validation is evaluated independently of the cell. In other words, I was assuming that it was checking if the value returned by the expression was equal to the current cell. In reality, it was checking to see if =eomonth(A169,-1)+1 equaled "true" (or -1, I suppose). There are 2 potential solutions here. Maintain "Custom ...


1

List from a range option of data validation doesn't work that way. You could try to use a custom formula, but this option doesn't show a dropdown.


1

AFAIK, at this time it's not possible to apply the desired format (0.00), but other formats like date, percentage works fine. Currency also doesn't work.


Only top voted, non community-wiki answers of a minimum length are eligible