Using the average and standard dev formula

I am trying to use an average formula to get the average of data from the past 30 days. I tried using collect but seem not to be working as it gives me an error. I also am using standard dev formula both for the past 30 days/data before that row. Please help.

Best Answer

  • Darion Albert Roque
    edited 04/13/22 Answer ✓

    My apologies, I was able to figure it out to get the average from the past 30 days, however what I actually need was last 30 entries. This is the formula that I got to work.

    =AVG(COLLECT([Tensile Strength]:[Tensile Strength], [Test Date]:[Test Date], <=TODAY(), [Test Date]:[Test Date], >=TODAY(-30)))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!