I want to automatically populate a calendar sheet with scheduled meetings as team members select dates for events/meetings on different sheet
I think this is a really simple problem but I am struggling to find the right method/function. I have a Google spreadsheet with a sheet called "Calandar" which is just a column of each day of 2024, starting at 01/01/2024, and ending on 31/12/24.
[https://docs.google.com/spreadsheets/d/1zNgzM0jJd84Pi_Z6rGK7qyMfX7qGMRkbpf4fIYpnhEE/edit?usp=sharing]
The second sheet is called "Data" and this is where the team members record the event type and the date they want.
I need the "Calandar" sheet to compare the dates and insert the events in the correct rows according to the dates supplied in "Data", and I need this to be automatic.
I have researched the xlookup function but I want to compare the whole range Calander!A2:A366 against the range Data!B2:B, and return the record in the corresponding column in Data!A2:A. Nothing I have found seems to compare the range to the range - and then the duplicate dates in Data!B2:B are a problem too.
You may try this xlookup formula in Cell_B2 of Calendar tab:
=arrayformula(xlookup(A2:A&B1:F1,Data!B:B&Data!A:A,Data!A:A,))
- Colouring cells in conditional formatting by the content in a neighbouring cells in Google Sheets
- How do I use XLOOKUP for multiple criteria?
- conditional formatting on a single cell where criteria is another column
- How to incorporate INDIRECT to reference a tab name Into a Index and match formula in google sheets
- How to create a drop-down list with a maximum quantity?
- Google spreadsheet direct download link for only ONE sheet as excel
- Multiple nested if blocks in google spreadsheets formulas
- Count values in multiply columns as in single one, group by other column
- How to prefill Google form checkboxes?
- Is there a way to have a Form submit responses to a specific sheet in a spreadsheet?
- Form title from FormResponse
- Infinite execution of the code in Google apps script
- Error with Phone Number Format in Goolge Sheets
- Grabbing URL from @ formatted cell
- Google sheet query to sum columns dynamically determined by a multi-choice selection from a dropdown
- Automatically Sort Data in Google Sheets onEdit
- How do I import JSON from a URL in Google Sheets?
- How do I write a formula in Google Sheets to find the current period in a fiscal year depending on today's date?
- how to get a loop iteration number as value in google apps script?
- How to avoid re-authorization of App Script?
- Paste multiple rows and generate ID for them
- Is there a google sheets function to count blank cells and stop when it reaches a full cell?
- Is there a way to create a Sheets Table from apps script?
- Google Sheets - replace the exact text/number with a different one ignoring other matching parts
- "format" true/false to something like "yes/no" in Google Sheets
- How to count number of non-blank cells (cells that contain text)?
- Sort Sheet Range in Natural Order
- Which would be the most time efficient way to replicate a formula through N cells
- Why has my onEdit Script stopped triggering?
- How do I get the column letter of a single row where a particular value equals a test value?