I am trying to make an employee clock in/out app. I’m trying to make it where the employee can give a reason why they are late if they clock in late, but I’m having trouble with the SHOW_IF formula.
=IFS([Time In]>“08:30:00”, [Clock In] = “Clock In”)
When I put the date time in as “08:30:00” it shows in verify as “12/30/1899 08:30:00 AM”
The [Clock In] is an enum with the only value of “Clock In” The [Time In] is a ChangeTimestamp type Column that activates when someone hits “Clock In”
I’ve tried adding (TODAY()+“08:30:00”) and some other alternatives but they don’t seem to work. Can anyone help?