Reference a sheet with today's date as the name
I currently have a Google sheet with an apps script and timer that generates a new sheet once a day, with today's date as the name. The new sheet is automatically named "11/1/2024", tomorrow's sheet is automatically named "11/2/2024", etc. Using IMPORTRANGE, I want to import the data into a separate sheet file. But I only want it to import information from the most current sheet in the first file, the one with today's date.
The way I currently have the IMPORTRANGE formula set up, it is referencing a specific sheet name, i.e. =IMPORTRANGE("link","11/1/2024!A1:A50"). This works great for a day, but I want to implement a formula that will dynamically update each day to source the sheet with that day's date. I've tried implementing TODAY instead of the sheet name into the IMPORTRANGE formula, but it doesn't work.
Any assistance is appreciated, thanks in advance.
Edit: pgSystemTester did a wonderful job showing me a formula that worked for this situation, please see below. In Spreadsheet 1 I had to create a master sheet, which would reference the sheet with today's date and reflect that data. In Spreadsheet 2, a separate file, I could then use IMPORTRANGE to import the data from the master sheet in Spreadsheet 1. The master sheet in spreadsheet 1 was always updating to reflect the data of the sheet with today's date, and Spreadsheet 2 would import that updated data.
After more research I found another formula that works as well and eliminates a step. For anyone struggling with the same issue, this is the formula to import data from one google sheet to another citing the sheet with today's date as the title Using IMPORTRANGE:
=IMPORTRANGE("YOUR_SOURCE_SPREADSHEET_URL", TEXT(TODAY(), "MM/dd/yyyy") & "!A1:B10")
Depending on the date format you can use INDIRECT with TODAY and Text. This works for me...
=indirect("'"&text(today(),"MM/DD/YYYY")&"'!A5")
- Calculate difference of values in specific range of time in Excel
- Select from series of columns without blanks and then where Google Sheets query
- How to make previous dates data from one tab appear in another tab
- Replace form response email address with name from master list
- Issue while applying Sumifs arrayformula to whole column
- Google Spreadsheet Last X Rows
- Select rows that contain a specific dropdown value
- Byrow formula with reference to last row and last column
- find a column where specific rows contain specific values
- Conditional criteria in a query formula
- How to Append an Executable SUM Formula to Google Sheets Using Python?
- Google Sheets - Index, Match, & Importrange - What is wrong with my formula?
- Vlookup function for criteria contained in a multiple selection drop down list
- How to join unique strings in their own column with QUERY?
- Reference a sheet with today's date as the name
- ARRAYFORMULA with GOOGLEFINANCE function
- Returning the last input entry
- How Do I Give rows in a table of contents a key. Then look up the key Later using the data from the rows in table of contents?
- Setting the maximum for a cell
- Array Formula to omit certain values
- Google Sheets Query While Removing Duplicates
- NAME error hiperlink function Apps Script Google Sheets
- Can I use a named range as column headers?
- Formula is currently double-counting a cell
- Search for targets and indicate where they come from
- Specifying a time span / duration constant in Google Sheets formula over 24h
- How do I sum the max of each categories without helper column
- Textjoin with multiple conditions
- Generate unique random numbers in Google Sheets
- How to prevent the SPLIT function from converting text to non-text in Google Sheets