Formula - Where did I go wrong?


I'm trying to create a formula that shows what is the average cycle time in one month, per month. I have a column that's for (Total Cycle Time) and another column that has the Requested Date. Thanks!

=AVG({Copy of Change Request Range 4}{Copy of Change Request Range 5}, IFERROR(MONTH((@cell)=1)))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!