I've been struggling with this for a few days now and wondered if anyone could help!
I have a SharePoint list (attendance tracking) with 4 date columns:
- Arrival Time (this is filled-in using [Today] by default when the item is created)
- Exit Time
And a text column called Status.
I want the Status column to quickly show whether the person is in the building, or out, based on the 4 date columns (e.g. if there is a time/date in the Arrival Time column, but not in Sign-out column then they are in the building.
I am trying to adapt some json on GitHub but I am really struggling to get the if statements down!
Any help would be greatly appreciated!