Hi Guys,
I have two tables, the 1st one is where I create the schedule, and the other one is for the timekeeping.
The 1st table has the column Name / Date / Time IN Schedule.
The 2nd table has the Punch Ref Number / Name / Date / Time IN schedule / Punch In Time/ etc…
The Name is to the USEREMAIL(), the Date is TODAY().
What I need is for the Time IN schedule will autofill based with the matching Name and Date columns on both tables.
How to??? thanks
How about… ANY(SELECT(1stTable[Time IN Schedule],AND([Name]=[_THISROW].[Name],[Date]=[_THISROW].[Date])))
@Aleksi_Alkio Thanks!
Translate
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |