Duration Formula

Hello, Trying to recreate a formula i wrote in a previous role to track duration for a monthly average. My formula is written as so:

=IFERROR(SUMIFS({Duration}, {Duration}, ISNUMBER(@cell), {End}, ISDATE(@cell), {End}, (IFERROR(MONTH(@cell), 0) = 1), {End}, (IFERROR(YEAR(@cell), 0) = 2024)) / COUNTIFS({Duration}, ISNUMBER(@cell), {End}, ISDATE(@cell), {Duration}, (IFERROR(MONTH(@cell), 0) = 1), {End}, (IFERROR(YEAR(@cell), 0) = 2024)), 0)

on my source sheet {Duration} is calculated in this formula =IFERROR(NETWORKDAYS([Initial Call]@row, [First Bill Emailed]@row), 0) / 12

My date column is in the date formatting. Not sure why I am getting no return on the first formula i should have an average for January as 1.96

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!