TRANSPOSE function with condition of special date

Question

I have a perfectly working function:

TRANSPOSE(SPLIT(ArrayFormula(JOIN(" , , , , , ,";FILTER('REELsatış'!C2:C1500; 'REELsatış'!C2:C1500 <> "")));","))

It uses the data from the sheet REELsatış:

And gives me the following result on another sheet:

But it need it to use only the records of today. I mean that it shows 14.07.2021 today, and tomorrow it will show 15.07.2021. How can I put this condition in this complicated formula?

share a copy/sample of your sheet with example of desired result — player0
– player0, Commented Jul 14, 2021 at 17:52

player0 · Accepted Answer · 2021-07-14 18:19:15Z

1

try:

=TRANSPOSE(SPLIT(ARRAYFORMULA(JOIN(" , , , , , ,"; 
 FILTER('REELsatış'!C2:C1500; DATEVALUE('REELsatış'!C2:C1500) = DATEVALUE(TODAY())))); ","))

edited Jul 14, 2021 at 18:19

answered Jul 14, 2021 at 17:54

player0

131k14 gold badges92 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sanli Over a year ago

Thank you for the fast answer) Unfortunately, it can't filter the dates with the timestamps. Is it possible to make it see the date in the timestamps?

Sanli Over a year ago

The timestamps are important, they are like the ID of the line.

Collectives™ on Stack Overflow

TRANSPOSE function with condition of special date

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related