Hi guys,
Working in BC I'm trying to make a list that shows a list of all my resources and if they have a timesheet in the period set in a filter.
But if a resource doesn't have a timesheet created, I get an error I would just like a blank field.
It works for the first resource who also have a timesheet in the period.
This is the error:
This is my NL rows:
This is the NL I use to find the timesheet related to the user:
Anybody got a good advice ?
If it works on the first resource returned and then gives a #VALUE on all the subsequent resources, my guess is that you need to lock the references to your Starting Date and Ending Date. Should be Options!$C$2 and Options!$C$3
If that NL First occurs in the rows replicator, the function moves down with each row, thus changing the reference to your dates to C3 and C4, then C4 and C5, etc. but your date on the option page is not moving.
Hi Bryan
That did it - thanks for your feedback.