Adding a Date require to IF statement

Options

Hello,

I'm looking for assistance in adding some criteria to this AVERAGEIF formula to make it so I am only averaging dates from this year.

=AVERAGEIF({Completed - Department}, =[30 Day Post Release Quality Score - Segments]@row, {Completed - AQualityP30D})

There is no AVGIFS so I'm not sure how to appraoch this any assitance is appreciated!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!