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?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!