New answers tagged

0

I do not think that the options clause has any effect when you are using Google Visualization API Query Language in a query() formula. The format clause works fine in a query() formula, but it does not let you transfer cell formatting such as font size, bolding or color. It only lets you specify number formatting for integers, floats, dates, times, datetimes ...


0

This formula gets just the contacts where Month Added matches the month in cell A2: =filter('Contact List'!A4:F, 'Contact List'!A4:A = A2) See the new 'Attendance Jan - filter()' sheet in your sample spreadsheet. The formula is in cell A3. Note: it appears that your intention is to manually add data side-by-side with the formula that reads data from the '...


0

If you only need 5 rows then use: =IMPORTRANGE("https://docs.google.com/spreadsheets/d/1vTcYJ8P5Ai3g4EME8Ye6B3qT0KHKNlr5pP7jpTPIxl4/edit","Attendance Jan!A3:E7") The formula is importing 48 rows you will be able to write on the row 49 after the row where the IMPORTRANGE formulas was added. Let say that the formula was added row 10 you ...


Top 50 recent answers are included