Using condition to warn/suggest user

[P_S]

Hi all,

I am trying to create the condition to check the shift of workers. If the worker who has name on that shift shouldn't taking care more than one room on the that shift. And worker cannot work for 24 hours, they can work 2 shifts on the same day or 2 days like Noon and Midnight shift. Each condition can be separate. Is that possible?

I also attach qvf file with this post.

Thanks in advance

[P_S]

Any Suggestion?

I am trying to use this condition

=If(Date_1 = Date(Date(Date_1)),
If(Shift = Shift,
If(Count(Total ID) > 2, 'Good', 'Bad')))

But all result show as "Good". It cannot show who has the shift and got 2 rooms as "Bad". Where do I miss?

**I change Date field name into Date_1**