How to edit filter to include YEAR function

So I had this formula created and its searching by a couple of different metrics to gather the average of a column but only via the supervisor name for another column. Silly me forget we only need to spit back data from 2024 as the sheet collects multiple years worth of data and my brain is really struggling to add this addition to a formula without breaking it for some reason.

I need to take the formula below and just update it enough to include also searching for responses only within the year 2024. Any help would be appreciated :)

Current formula:

=IFERROR(AVG(COLLECT({30 Day Q 1}, {30 Day Supervisor}, [supervisor]2)), 0)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!