one entry showing in all entries

[Dwayne]

i have two sheets,  and attendance register and attendance sheet.

each user logs in each day, and genrate an attendance sheet to file the weeks entries per user.

but if on user logs on th register and i pull a sheet the one user register is carried to all users.

using this as formula on the Attendance sheet

TEXT(SELECT(Attendance register[Time in],
AND([Employee ID]=[Employee ID],
[WeekNum]=WEEKNUM(NOW()),
[Day]=1),true))

please assist, as shouls only record teh specific users entry

[Markus_Malessa · Accepted solution]

I think what you need to change is [Employee ID] = [_THISROW].[Employee ID]

[Dwayne]

Thanks a mill, sorted, when pulling report it is only showing the selected employees logged data.