Forum Discussion
Count only Scheduled Employee's
I think we're on the right path and i'm just having trouble putting all the pieces together.
The issue i'm having now is only counting the people scheduled for "Today" as indicated by the Day code in Q4
I've attached your previous file with different attempts at getting this to work.
It isn't very clear what exactly you need but I THINK what you need is to convert the schedule text into an actual list of days so you can compare any given to that list. In the attached I created a LAMBDA function that can do this for you so then you just need to compare to see if any given day is in that list. If this isn't what you need, maybe you could explain more.
I think we're on the right path and i'm just having trouble putting all the pieces together.
The issue i'm having now is only counting the people scheduled for "Today" as indicated by the Day code in Q4
I've attached your previous file with different attempts at getting this to work.
I think all you needed to do was add parantheses so that product is inside the SUMPRODUCT like this:
=SUMPRODUCT(('Active Associates'!G:G=Sheet2!B3)*('Active Associates'!H:L=Sheet2!Q4))I'm hoping you can help me with this last issue I'm having.
Here's where i'm currently stuck at.
I've highlighted the cells in yellow. I'm trying to show that "Today" I should have 4 people on site. The rest of the day's should be blank or "0" because it's not "Today".I've got the date, and a Day code up top to help but I'm just not able to calculate it correctly.