I have a scenario when a time-dependant workflow needs to be triggered when the case status is new and specific users with specific roles are logged in.
AND(ISPICKVAL(Status, "New"),
OR(
$UserRole.Name = "Role 1",
$UserRole.Name = "Role 2",
$UserRole.Name = "Role 3",
$UserRole.Name = "Role 4",
$UserRole.Name = "Role 5",
$UserRole.Name = "Role 6"))
So basically when the status is new and some of the roles are logged in the time dependant workflow needs to be activated after 60 minutes.
In my case, I am using a custom field that is 5 minutes from now so I can test the scenario in the next 5 minutes. For the custom field, I am using
The formula for Trigger Time 05
=NOW()-0.038
What I am doing wrong?
Cheers Darko