About 1,394,487 results (5,697 milliseconds)
Give the sheet name to a cell automatically - Google Docs Editors ...
https://support.google.com/docs/thread/48798217/give-the-sheet-name-to-a-cell-automatically?hl=en May 23, 2020 ... In cell E2 of your sheet, I used the new formula =SHEETNAME(0) which puts the name of the current sheet into the cell. I hope this helps! Adam.
Using Indirect to put a sheet name and cell reference together not ...
https://support.google.com/docs/thread/149906414/using-indirect-to-put-a-sheet-name-and-cell-reference-together-not-working-when-sheet-name-updated?hl=en Feb 8, 2022 ... Just want to add as an aside, that the Indirect formula you've created has unnecessary punctuation. I've left a streamlined version of your ...
How can I set sheet name ! to a cell value in a function? - Google ...
https://support.google.com/docs/thread/154394429/how-can-i-set-sheet-name-to-a-cell-value-in-a-function?hl=en Mar 10, 2022 ... I have a google sheets that has the tab names to the left and a funtion to the right to load in the data. =VLOOKUP("serch for this",'TAB NAME'!A1:B8,2,FALSE)
QUERY from multiple sheets, need name sheet. - Google Docs ...
https://support.google.com/docs/thread/93010327/query-from-multiple-sheets-need-name-sheet?hl=en Jan 11, 2021 ... I need to add the name of the sheet where this line comes from to each line. The sheet name is in the formula range, on each sheet. Is there a solution?
Populate Sheet name into ImportRange - Google Docs Editors ...
https://support.google.com/docs/thread/190675691/populate-sheet-name-into-importrange?hl=en Nov 29, 2022 ... I am trying to import data from one google sheet to another using the IMPORTRANGE function. The issue is I need to import multiple cells from multiple sheet ...
Using a cell value as worksheet name in an Index Match formula ...
https://support.google.com/docs/thread/182192198/using-a-cell-value-as-worksheet-name-in-an-index-match-formula?hl=en Oct 3, 2022 ... I am a Google Sheets/Excel novice. I have tried different variations of INDIRECT but can't get the formula to reference G2 (which for example ...
Referencing data from another sheet using a variable sheet name ...
https://support.google.com/docs/thread/4078098/referencing-data-from-another-sheet-using-a-variable-sheet-name?hl=en Apr 12, 2019 ... Using this formula to reference data from another sheet (sheet names are years)... =2018!M47. Is it possible to reference a cell address instead of hard coding ...
Name a range of cells - Computer - Google Docs Editors Help
https://support.google.com/docs/answer/63175?hl=en&co=GENIE.Platform%3DDesktop Open a spreadsheet in Google Sheets. · Select the cells you want to name. · Click Data and then Named ranges. A menu will open on the right. · Type the range name ...
Return sheetnames from multiple sheets if meets criteria - Google ...
https://support.google.com/docs/thread/107538347/return-sheetnames-from-multiple-sheets-if-meets-criteria?hl=en Apr 25, 2021 ... I am trying to search a column in each tab that match a cell and return the sheet name. here's an analogy,. Product id in column A. Searching ...
Reference data from other sheets - Computer - Google Docs Editors ...
https://support.google.com/docs/answer/75943?hl=en&co=GENIE.Platform%3DDesktop Open or create a sheet. Select a cell. Type = followed by the sheet name, an exclamation point, and the cell being copied. ... Add formulas & functions. 2 of ...
Can you dynamically build the 'sheet name'!Cell Reference part of ...
https://support.google.com/docs/thread/40307606/can-you-dynamically-build-the-sheet-name-cell-reference-part-of-the-match-formula?hl=en Apr 16, 2020 ... I'm trying to get the match formulas in cell B25 on the 'Monthly View' tab to be dynamic as it pertains to the sheet name.
Auto insert sheetname into chart title?
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/ge-mhPirod4 May 8, 2010 ... Microsoft MVP Excel SalesAid Software [email protected] "Bob Ryan ... one cell, the sheet name formula in another cell and either use the
Date each sheet according to sheet number 1-31 | Consecutive ...
https://support.google.com/docs/thread/137477697/date-each-sheet-according-to-sheet-number-1-31-consecutive-dates-over-different-sheets-extract?hl=en Nov 27, 2021 ... This will take the date you place in the top cell of the Monthly Salary, add the number from the name of the sheet and then subtract one to ...
Bulk resolve "unresolved sheet name"?
https://groups.google.com/g/google-analytics-spreadsheet-add-on/c/X4ICMWhYDV4 Dec 28, 2018 ... ... cell in each column and just hold down the return key. I'll keep this open for a smarter explanation, solution. Still new at Google Sheets add- ...
How can you influence the 'starting' field when opening sheets ...
https://support.google.com/docs/thread/32097728/how-can-you-influence-the-starting-field-when-opening-sheets?hl=en Mar 2, 2020 ... function onOpen() { // version 1.1, written by --Hyde 5 March 2020 // - add sheetName, dateColumn // - use value.
Error "Unresolved sheet name" when copying tabs from one google ...
https://support.google.com/docs/thread/12478976/error-unresolved-sheet-name-when-copying-tabs-from-one-google-sheets-file-to-another?hl=en Aug 21, 2019 ... on the individual cell with the error message, the problem is resolved and the formula is then ok. But as I cannot do so for hundreds of cells ...
Get current sheet name in cell - Google Docs Editors Community
https://support.google.com/docs/thread/8603869/get-current-sheet-name-in-cell?hl=en Jun 24, 2019 ... Get current sheet name in cell · Go to one of the menu items in the Add-on menu: Add-on > Formulas by Top Contributors > MATRIX formula · This ...
Get name of current sheet (where the formula is entered) - Still ...
https://support.google.com/docs/thread/9818870/get-name-of-current-sheet-where-the-formula-is-entered-still-unresolved-since-2013?hl=en Jul 13, 2019 ... How do you get the name of the current sheet in a cell? This thread reports a bug that seems unresolved to this day:
Formula to reference EVERY sheet in a workbook, even new ones ...
https://support.google.com/docs/thread/194160919/formula-to-reference-every-sheet-in-a-workbook-even-new-ones-added?hl=en Dec 24, 2022 ... Or, if this is what you are suggesting, you maintain a list of tab/sheet names, adding to it as you add sheets, and the formula can reference ...
How to automatically change a sheet name to the text entered into ...
https://support.google.com/docs/thread/109495829/how-to-automatically-change-a-sheet-name-to-the-text-entered-into-merged-cells-on-a-different-sheet?hl=en May 11, 2021 ... Cells on Student 1's sheet auto pull the data entered into cells B2-B15 on the 'Student Data' sheet. Each student's sheet is set to pull their ...