Average time to fill for a given month

Alex Hackford
Alex Hackford ✭✭✭
edited 10/01/21 in Formulas and Functions


I'm looking to calculate the average TTF (time to fill) for a given month and was attempting to use a combination of AVGIF/AND to do so. The formula I have is : =AVERAGEIF({Hiring Plan Range 1}, AND({Hiring Plan Range 2} >= DATE(2021, 1, 1), {Hiring Plan Range 2} < DATE(2021, 1, 31)){Hiring Plan Range 1})

Hiring Plan Range 1 = Time to fill column

Hiring Plan Range 2 = Offer acceptance date column

I'd like to show this over time for the year so I'm looking to calculate each month individually. Basically I'd like to average the TTF value when they fall between the start/end of the given month in the Offer Acceptance Date column.

Any suggestions on how I can improve my formula above? I'm getting #Unparsable as is.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!