How to combine AVG and TODAY Function

tmagana

tmagana ✭✭

12/20/23 in Formulas and Functions

I want to take the AVG of that column but only take the past 30 days from another column.

Thanks in advance for any help😊

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

12/21/23

You would use an AVG/COLLECT combo.
=AVG(COLLECT({Range To Average}, {Date Range}, @cell>= TODAY(-30)))

Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

How to create a formula column that calculates the difference between rows?
I have a sheet1 with columns labeled "Metric Name," "Plan-Actual," and monthly columns where we record the plan and actual numbers consecutively for the same metric name. Metric Name Plan - Actual Last FY - Jun Last FY - Jul Last FY - Jaug Test-01 Plan 90 89 21% Test-01 Actual 90 79 78 Test-02 Plan 90 100 120 Test-02…
Why is 'DAY' Value from a Date being populated incorrectly?
I have a 'Formatted Date' column with a column formula (below) that formats the date from the row's date timestamp, which I renamed to 'Training Completion Date', into DD-MMM-YYYY format. All rows but one is getting the correct day from the DATE. I cannot figure out why 10/08/24 returns 9-Oct-2024. Curious to know if…
Counting items in a cell separated by comma
Hello, Thank you in advance. Need help getting the count of the values in a cell that are separated by a comma. Example in a Cell I could have three values: Blue, Green, Yellow. Need to return the value 3 but I can't seem to find that anywhere in the community. Thank you again!