Median formula showing highest value from range.


Hi everyone,

I have two sheets, a master sheet with cost data and a metric sheet with formulas to get a summary.

In metric sheet, I need median value of certain items. I have used MEDIAN & COLLECT.


When I updated the formula, I got the correct median value. But after sometime, the metric sheet gets refreshed automatically and the cell with median formula shows the highest value from that range.


Product 1 5000

Product 2 8000

Product 3 3000

The median should be 5000. But the metric sheet gets refreshed and I get the value as 8000.

Is there something wrong with the way I am using the formula or the way data is set up?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!