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'm trying to set the RYG status of a task based on End Date and % Complete of the task.  I've put a formula in place using =IF(AND(...  but I keep getting the error "# INCOMPLETE ARGUMENT SET"

Below is the formula, can anyone tell me what I'm doing wrong or missing, please....