Find Next Timestamp Below current row based on Employee Name.
I have a list of time entries that are populated when barcodes are scanned.
ID 1 - Bill - 06/15/21 1:59PM - Part1 - new cell(6/15/21 3:00PM)
ID 2 - John - 06/15/21 2:35PM - Part2 - new cell(No Entry Yet)
ID 3 - Bill - 06/15/21 3:00PM - Part 3 - new cell(06/15/21 4:30PM)
ID 4 - Bill - 06/15/21 4:30PM - Part 4 - new cell(No Entry Yet)
I'm trying to populate a new cell the employee's next timestamp based on Employee Name. So I need a formula to look below the current entry for the first entry that matches the employee name, and grab the timestamp from the entry it found to populate a end time in the new cell.
Here's what I tried, I'm sure I'm not even close:
=IF([Start Time]@row = MIN(COLLECT([Start Time]:[Start Time], [Employee Name]:[Employee Name], =[Employee Name]@row,[Time Log ID]:[Time Log ID], [Time Log ID]@row>1)[Start Time]:[Start Time]),[Start Time (H+M)]MATCH(),0)
Thanks
Best Answer
-
I have no clue what I did, but it works now.
=IF([Start Time (H+M)]@row > 0, MIN(COLLECT([Start Time (H+M)]:[Start Time (H+M)], [Employee Name]:[Employee Name], =[Employee Name]@row, [Time Log ID]:[Time Log ID], MATCH([Employee Name]@row, [Employee Name]:[Employee Name]) > [Time Log ID]@row)))
Answers
-
I have no clue what I did, but it works now.
=IF([Start Time (H+M)]@row > 0, MIN(COLLECT([Start Time (H+M)]:[Start Time (H+M)], [Employee Name]:[Employee Name], =[Employee Name]@row, [Time Log ID]:[Time Log ID], MATCH([Employee Name]@row, [Employee Name]:[Employee Name]) > [Time Log ID]@row)))
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives