Including Holidays


Maybe someone can help me figure this out. WHen i use the below formula I get a number in return or a blank if there is missing data in the assignment form approved date or the disposition date fields. so the formula is exactly how i want it. My problem however is when I add holidays

=IFERROR(NETWORKDAYS([Assignment Form Approved Date]@row, [Disposition date]@row), " ")

If i add the holiday column the return is a blank in every row

=IFERROR(NETWORKDAYS([Assignment Form Approved Date]@row, [Disposition date]@row), Holidays:Holidays)," ")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!