How do I get a range of values from another sheet to feed NETWORKDAYS w/ holidays formula?

Options

Hi,

I'm super stumped on this one and can't find a solution.

I have 2 sheets:

  1. The destination sheet is where I'm building the NETWORKDAYS w/ holidays formula
  2. The source sheet is called "Shutdown Days" and has 2 columns - "Client" and "Date". See screenshot below.

I need to just pull the range of dates into the NETWORKDAYS formula where Client = "AXEL8".

While creating this post, I figured out the solution. I'm posting anyway for anyone else who bumps into this.


=NETWORKDAYS([DRYWALL START]@row, [DRYWALL END]@row, COLLECT({Shutdown Days - Date}, {Shutdown Days - Client}, "AXEL8"))




Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!