I want to make a sheet summary field return whatever is in row 6 of the activecell's column. It has to dynamically change with the cell's position.
Similarly, based upon the activecell's row, I want to return the value of Column 2 of that row.
Excel has a feature for ActiveCell which then you can use Offset or Index to return differnt columns or rows from the cell that is active.
We need this functionality in Smartsheet.