AverageIF- Date range and multiple criteria from SS source


I keep getting unparceable, please help!

Need the average of all days in source 1that meet this criteria: source 2 ="closed", and source 3 has a date range of 1/1/21-3/31/21.

Source 1-{Tracker Range 8}

Source 2- {Tracker Range 4}

Source 3- {Tracker Range 3}

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!