I'm trying to calculate the values in a column if within a certain range, I am getting 0. Any help?l

Options

=SUM(COLLECT([Total]:[Total], Date:Date, NETDAYS(24 / 1 / 6, 24 / 30 / 6) = 30))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!