Holiday list for Networkdays using Join-Collect?
I have a use case where I need to calculate Networkdays using holidays that are dependent upon location of the resource. I am trying to avoid nested IF statements if possible. I am attempting to populate the [Holidays] field using a Join-Collect function combo to a single list of holidays for all locations. I am getting an error I suspect from the format of the holiday list that Join-Collect produces. Any thoughts?
Help Article Resources
Check out the Formula Handbook template!