Using the average and standard dev formula
Best 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)))
Answers

Can you please show the formula and the error message you are using/seeing to help diagnose?
Typically using collect would look like this:
=AVG(COLLECT({range you want to average}, criterion range 1, criterion 1, criterion range 2, criterion 2...)
Hope this helps!

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)))

Glad it worked out!
Help Article Resources
Categories
Check out the Formula Handbook template!