I have a sign out/in application for my clients, I am going to create a workflow that emails their case manager if they missed curfew.
So what I am having trouble with is wording the expression that will make the column “Missed Curfew” true or false.
This is what I have come up with but ummmm it’s not gonna work lol
Solved! Go to Solution.
You might want to try something like:
OR(
AND([Date]=TODAY(), ISBLANK([Time In:])),
AND([Date]=TODAY(), [Time In:]> TIME(“19:00:00”))
)
You might want to try something like:
OR(
AND([Date]=TODAY(), ISBLANK([Time In:])),
AND([Date]=TODAY(), [Time In:]> TIME(“19:00:00”))
)
User | Count |
---|---|
43 | |
29 | |
23 | |
21 | |
13 |