Formulas Question  Referencing Another Sheet
Good morning,
I am trying to pull calculate an average from data being pulled from another sheet. I want to be able to calculate the average duration, by month of completed projects.
I basically want to say what is the average of the duration fields if the phase is completed and the end date column is in the month of January and the year 2022.
What is the easiest way to do this every way I try to end up with an error.
Thank you,
Tiffany
Answers

You are going to need an AVG/COLLECT.
=AVG(COLLECT({Duration Column}, {Phase Column}, @cell = "Complete", {Date Column}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2022))
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 216 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!