Error Using Max Function

Having an issue with the Max formula. Appreciate any advice the community can provide.

This formula is giving me an Invalid Column Error:

=MAX([End Date]195:[End Date]220)

However, this one works fine so I don't see why there would be an invalid column error on the first formula.

=NETWORKDAYS([End Date]207, [Start Date]@row)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!