Average IF Within 30 days

Hello,


I am trying to figure out a formula to average a particular column of information, but only within the last 30 days. I have a "Todays Date" Formula/column already created, but not sure how to write the formula to be able to read my whole column of data but only pull from the past 30 days.


I appreciate any help in advance.


Thank you,

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!