About 1,225,589 results (4,799 milliseconds)
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 ... I'm not a scripter but I do have this one in a document with 3 tabs and it returns the appropriate tab name for each. function sheetName() {
Get the active sheet's name to be in a cell - Google Docs Editors ...
https://support.google.com/docs/thread/87383462/get-the-active-sheet-s-name-to-be-in-a-cell?hl=en Dec 7, 2020 ... I want that new sheet name to appear in cell A2 of each sheet. hopefully this can be done with a formula. I am not familiar with how to run ...
Dynamic Formula Referencing Another Sheet - Google Docs Editors ...
https://support.google.com/docs/thread/201506996/dynamic-formula-referencing-another-sheet?hl=en Feb 11, 2023 ... ... spreadsheet, how do I make the tab's name in the formula dynamic. ... If I have many other formulas in my current sheet referring to another tab ...
Lock a sheet name within a formula so that the formula will not ...
https://support.google.com/docs/thread/201235153/lock-a-sheet-name-within-a-formula-so-that-the-formula-will-not-change-if-the-sheet-is-renamed?hl=en Feb 9, 2023 ... ... sheet (named: 'Current Week'). The data in 'Current Week,' as you ... My knowledge of excel is purely based on: I know what I want to ...
Lookup and display a range according to the name on a sheet (tab ...
https://support.google.com/docs/thread/106121227/lookup-and-display-a-range-according-to-the-name-on-a-sheet-tab?hl=en Apr 13, 2021 ... Then in J1, place the desired role of the current tab. I just chose ... Ideally, I could use the name of the sheet as part of the formula ...
Average same cell across a range of worksheets - Google Docs ...
https://support.google.com/docs/thread/110834752/average-same-cell-across-a-range-of-worksheets?hl=en May 22, 2021 ... Sheets doesn't have a native function to offer 3D data referencing in the way that Excel does. ... tab names (for both current and future tabs) ...
Formula that will reference specific cells in every tab in the Sheet ...
https://support.google.com/docs/thread/181262219/formula-that-will-reference-specific-cells-in-every-tab-in-the-sheet?hl=en Sep 28, 2022 ... The way I would do it is to create multiple dummy tabs using the template and and add the dummy tab names to the formula. That way you will ...
Display file name in a cell - Google Docs Editors Community
https://support.google.com/docs/thread/151853009/display-file-name-in-a-cell?hl=en Feb 22, 2022 ... Hopefully you can copy it for your real sheet? Give it a test and see if it works before trying to apply it to your own sheet. function onOpen(e){ ...
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 ... This script create the formula SHEETNAME. In cell E2 of your sheet, I used the new formula =SHEETNAME(0) which puts the name of the current ...
Class Sheet | Apps Script | Google for Developers
https://developers.google.com/apps-script/reference/spreadsheet/sheet Dec 2, 2024 ... Appends a row to the bottom of the current data region in the sheet. If a cell's content begins with = , it's interpreted as a formula. const ...
How do I resolve "error cannot find range or sheet for imported ...
https://support.google.com/docs/thread/11934357/how-do-i-resolve-error-cannot-find-range-or-sheet-for-imported-range?hl=en Aug 13, 2019 ... This is the current formula ... (ie You don't use the name of the file in the formula, you use the name of the individual tab/sheet.).
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 ...
Class SpreadsheetApp | Apps Script | Google for Developers
https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app Dec 3, 2024 ... This generally means the range that a user has selected in the active sheet, but in a custom function it refers to the cell being actively ...
How to rename a TAB based on a cell value? - Google Docs Editors ...
https://support.google.com/docs/thread/5236560/how-to-rename-a-tab-based-on-a-cell-value?hl=en May 1, 2019 ... ... name of the active sheet when ever you change a cell: function onEdit(e) {. e.source.getActiveSheet().setName(e.value);. } Hope that helps ...
"Unresolved Sheet Name" Workaround when copying or renaming ...
https://support.google.com/docs/thread/25074318/unresolved-sheet-name-workaround-when-copying-or-renaming-tabs?hl=en Jan 8, 2020 ... The Formula Errors will read "Unresolved Sheet Name" and will persist even after the referred Tabs are created or Tab Names are corrected.
Replace sheet, without effecting formulas? - Google Docs Editors ...
https://support.google.com/docs/thread/259802839/replace-sheet-without-effecting-formulas?hl=en Feb 20, 2024 ... A second option is to use your current approach, of renaming tabs, with Test_mod getting renamed to Test. ... tab names in those formula ...
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. For example, =Sheet1!A1 or ...
Vlookup to transfer data from one sheet to another (Same ...
https://support.google.com/docs/thread/109560838/vlookup-to-transfer-data-from-one-sheet-to-another-same-spreadsheet?hl=en May 12, 2021 ... After you make the needed changes to your weekly tabs, modify the formula to remove the "a" from the tab name reference. change & "a!AH6:AI ...
Make Graph with Dynamic Date Range - Google Docs Editors ...
https://support.google.com/docs/thread/37364777/make-graph-with-dynamic-date-range?hl=en Apr 1, 2020 ... ... formula are changed to match the name of your sheet containing data. So you will make sure you change graph to Sheet1 or whatever the name is.
Auto-Updating Cell Based on New Month - Google Docs Editors ...
https://support.google.com/docs/thread/74144796/auto-updating-cell-based-on-new-month?hl=en Sep 30, 2020 ... ... current month so I that I don't have to manually ... "Budget - Est' is the name of my actual "Projections" tab in my real spreadsheet.