Can you average a column per year?

I have set-up a metric for the Average of Actual Days to Completion (=AVG({CActual Days to Completion}) column for the whole tracker. The tracker is composed of requests received from 2022 to 2024.

Now my boss has asked me for the Average of Actual Days to Completion for requests received in 2023, only to see how we're doing. Can you please give me a formula regarding this?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!