I need help with this…it’s not picking up the OR part. I need something that says if check in and out are both blank so action. If both check in AND checkout are not blank show action. I don’t want the action to show if check is in not blank but checkout is blank.
AND(ISBLANK([Recent Row].[Check In Time]), (ISBLANK([Recent Row].[Check out Time]), OR(ISNOTBLANK([Recent Row].[Check In Time]), ISNOTBLANK([Recent Row].[Check out Time]))))
User | Count |
---|---|
15 | |
11 | |
10 | |
8 | |
3 |