CODEWITHSUNDEEP
google-sheets
IT VICEROY
IT VICEROY

Reputation: 13

GOOGLE SHEET FORMULA - QUERY STUFF FOR TODAYS DATE ONLY

new poster here :-) this place as helped me throughout my years of learning I.T stuff as I progress through Adulthood

So this formula im having an issue with with is for a Google SHeet.

basically I want a SHEET that only displays todays ATTENDANCE, and not YESTERDAY or previous dates attendance. So I have two sheets (Today) and (NewData)

New Data (Sheet) Picture Reference

TODAY Attendance Sheet Picture 2 Reference

now my formula is this as follows, the part that is broken is the ending (everything after =, as the = should reference cell B1 of Today Attendance Sheet, so it auto populates any new inputted data throughout the day

=QUERY(NewData!$A$1:$H$136,"select A, C, B where E = date '"&TEXT(DATEVALUE("1/1/2000"),"yyyy-mm-dd")&"'",1)

BROKEN WRONG CODE is “”””= date '"&TEXT(DATEVALUE("1/1/2000"),"yyyy-mm-dd")&"'",1)“”””

Upvotes: 1

Views: 183

Answers (1)

Gabriel Pierce
Gabriel Pierce

Reputation: 406

I like FILTER better than QUERY

=FILTER({'New Data'!A2:A,'New Data'!C2:C,'New Data'!B2:B}, DATEVALUE(LEFT('New Data'!A2:A,FIND(" ",'New Data'!A2:A))) = $B$1)

Todays Attendance Sheet

enter image description here

New Data Sheet

enter image description here

Upvotes: 1

Related Questions