How to display a multi-row table in Google Sheets based on date matching?

Other Questions Google Sheets
1

I’m working on a Google Sheets project and I’m stuck. I want to show a 9-row table when today’s date matches a date in column A. I’ve tried using an ARRAYFORMULA, but it’s not working as expected. Here’s what I’ve got so far:

=ARRAYFORMULA(IF(A2:A=TODAY(),ARRAYFORMULA($B$2:$F$10),))

This formula only shows the first row of the table. I also tried wrapping it in curly braces with an empty string, like this: {"",ARRAYFORMULA($B$2:$F$10)}, but that didn’t help either.

Is there a way to make this work? Maybe by shifting the data or stopping the array after it finds today’s date? I’m really scratching my head over this one. Any ideas would be super helpful!

2

hey olivias, i think i got a solution for ya. try this formula:

=FILTER($B$2:$F$10, $A$2:$A10=TODAY())

it should grab all the rows where the date in A matches today. lemme know if that works for u!

3

I’ve faced this issue before, and I found a workaround that might help you out. Instead of using ARRAYFORMULA, try this:

=IFERROR(INDIRECT(“B”&MATCH(TODAY(),A:A,0)&“:F”&MATCH(TODAY(),A:A,0)+8),“”)

This formula looks for today’s date in column A, then returns the corresponding 9 rows from columns B to F. The IFERROR function ensures you don’t get an error if there’s no match.

One thing to keep in mind: make sure your dates in column A are actual dates, not text. You can use the DATE function to convert them if needed.

If you want to display headers regardless of whether there’s a match, you could add them separately above this formula. Hope this helps solve your problem!

4

I’ve encountered a similar challenge before. Here’s an approach that might work for you:

=QUERY($A$2:$F$10, “SELECT B,C,D,E,F WHERE A = DATE '” & TEXT(TODAY(), “yyyy-mm-dd”) & “'”, 0)

This QUERY function searches for today’s date in column A and returns the corresponding rows from columns B to F. The DATE function ensures proper date matching. Remember to adjust the range if your data extends beyond row 10.

One advantage of this method is its flexibility. You can easily modify the selected columns or add additional criteria if needed in the future. Let me know if you need any clarification on implementing this solution.