How to get the average number of days within a quarter

here is my formula, but I keep getting an error. I can get the average, but now I want to know the average within Quarter 1

=AVG(COLLECT({DYS to Completion}, {Qtr}, "1"))

Tags:

Answers

  • kira11
    kira11 ✭✭✭✭

    If you have a column that says the quarter, I think you could do an average if, something like:

    =AVERAGEIF({Qtr}, 1, {DYS to Completion})

  • Peggy
    Peggy ✭✭✭✭✭

    I left out a criteria, need to know the average days to completion for a specific application within the quarter

    =AVERAGEIFS({Qtr}, 1, {Application}, =[Column5]@row, {DYS to Completion})

  • kira11
    kira11 ✭✭✭✭
    edited 11/22/24

    Oh got it, I think you could use the COLLECT() then. I think its the quotes around the 1, maybe try:

    =AVG(COLLECT({DYS to Completion}, {Qtr}, 1, {Application}, [Column5]@row))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!