1

You would just use and The only column containing a different variable is column B. So you could use =query(Sheet1!A:F, "SELECT A, B, C, D, E, F where E contains 'Apple' and B contains 'had'") Note: you do not need the parentheses around E contains 'Apple'


1

Please use the following formula in your synced copied sheets. =QUERY(IMPORTRANGE("xxxxxx","MasterDashboard!A2:F"), "select * where Col2= '"&B1&"' ") (where xxxxxx is your Master sheet ID and B1 is your reference cell in the synced sheet) Notes (for anyone using the formula) When using IMPORTRANGE one has to use Col1, Col2 etc To reference a ...


1

EDIT I just realized that you have cross-posted on both sites. I also realized that there is a much simpler case insensitive formula for your needs =COUNTIF(SPLIT(CONCATENATE(B1:B3), " "), "*heRO*") OR (if in cell A7 we have *HeRo*) =COUNTIF(SPLIT(CONCATENATE(B1:B3), " "), A7) If you want just the word Hero, remove the asterisks * around it. It also ...


1

You could use this formula =ARRAYFORMULA(IF((W10:W13<>"")+(X10:X13<>""),TODAY(),"")) and then give the desired date format to the results from the menu. (Please adjust ranges to your needs) Functions used: TODAY ArrayFormula IF


1

You can simply copy and paste into the sheets, there is no need to use the Insert Menu you have described. Follow these steps to add an image to a cell in a Google Sheet: Copy the Image from your source (eg take a screenshot with snipping tool) Open the Sheet & Paste the Image from your clipboard Select the Cell you would like to add the Image too ...


1

The following block "doesn't work" because it's inside of the first if block if(e.range.getA1Notation() === 'B5' && e.range.getSheet().getName()=='Temp1'){ if(e.value=='Base10') { e.range.getSheet().showRows(10,2); } try function onEdit(e){ if(e.range.getA1Notation() === 'B13' && e.range.getSheet().getName()=='Temp1'){ ...


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