Dec 7, 2020 ... hopefully this can be done with a formula. I am not familiar with how to run scripts in sheets. I have done it with excel in the past. Details.

May 23, 2020 ... In order to get the sheetname through the use of a formula, you need to use a script to create the custom formula.

Feb 22, 2022 ... I create a sheet daily, from a master sheet, usually a few days in advance and I save each one as a date, the dates can vary, ...

Mar 2, 2021 ... In cell A2, I then need the "Price" for 189 to appear. The list of item prices is held on a separate sheet called Pricing. The list is 25000 ...

Apr 21, 2021 ... I want to copy the sheet into a new sheet named: Street however, after I do that I rename the Tab to “Street”. I will click one of the cells ...

Apr 8, 2020 ... Email alerts sent to people when their name is entered into a google sheet cell. Hi,. I am trying to have an email alert sent to people ...

Jul 16, 2021 ... I've got a set of data that I want to import to a platform. They are names with associating contacts, however only the first cell in the column has the name.

Feb 11, 2023 ... ... in a cell and all my formulas should use this cell for tab's name. For reference I used one such formula in A2 of tab Help of the following ...

Jul 30, 2020 ... My goal is to be able to type the player's name in a cell in the "draft board" tab and then that player's name will be automatically crossed out on the "player ...

Apr 28, 2020 ... ... in the next cell? I have a list of student names and ID #s in separate cells on a second tab. On my first tab I'd like to select a student name ...

Jul 29, 2022 ... I'm trying to gather and consolidate information from a different worksheet tab, but I want to base the name on what I type into another cell.

When you convert your data to a table, we give it a name, as well as each column header. You can then use those names to reference cells in the table. For ...

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 ...

Apr 10, 2020 ... At the moment, I have both open and finding the named CELL in Excel, then writing my formulas in both. ... not very optimal.

Jun 18, 2019 ... A1 with the correct tab name and cell but in both cases keep them in double quotes, IMPORTRANGE expects text not actual ranges/URLs.

Feb 6, 2021 ... ... name "range 3" in a cell by cell structure. I wnat to reference the the cell in "range name 3", column B by range name in a new sheet in the ...

Feb 11, 2021 ... ... cell in the spreadsheet is hand edited. uses indirect functions to dynamically change the scope of data stored across multiple sheets. The ...

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.

Jun 9, 2021 ... ... sheets, so one way or another I imagine it is possible in Excel. ... name of the person(s) who has made changes to a sheet, and sort of ...

May 31, 2023 ... Cells that are merged into another cell are empty, and those empty ... You cannot hide cells with spreadsheet formulas, but you can weed blank ...