Average time to fill for a given month

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

Hi,

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.



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!