Average if when date is current year

edited 02/17/23 in Formulas and Functions

we want to update the formula to show the average # of problem solving days when the idea is a JDI and the opportunity was submitted in the current year.

Current formula - missing component to reflect only submissions from current year.

=AVERAGEIF({APD CI Tracker Range 5}, ="JDI", {APD CI Tracker Range 4})

{APD CI Tracker Range 5}- potential dropdowns "JDI:", "RCPS", or "Tech"

{APD CI Tracker Range 4} - average # of problem solving days

we also have a helper column for submission year I just am unsure how to incorporate that into my formula

can anyone help? :)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!