I want to be able to average, or other function, over a subset of the cells in a row.  The number of cells I want to include is specifiied in a separate cell.


In Excel, I accomplished this with OFFSET.  I read another article here noting that smartsheet doesn't have OFFSET, but that MATCH and



I had a question and figured maybe someone had done this already or knew of a tool that could do it. 

I'd like to utilize a form that submits values into a Smartsheet, then have Smartsheet perform calculations, and email the user an estimate. 

For example, I have Part X and Part Y.  The