Highest value on the last six values of data

I'm looking to find a formula that will capture the last six months of data and then return the highest value within those six values. On excel, I've used, for example, MAX(OFFSET(B3,COUNTA(B3:B113)-6,0,6,1)) but I see "offset" is not compatible with smartsheet. I don't believe Index and Match would work with what I'm trying to accomplish.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!