OFFSET() function
I've not seen any requests for a Smartsheet's equivalent to Excel's OFFSET() function. For how universal the INDEX(MATCH()) solution seems to be, it strikes me as a notable oversight that there isn't any function to achieve a similar effect for selecting a range of cells offset by a column index value. It would greatly simplify a few of my solutions to have a reference of a single 2-dimensional array where I could toggle the column instead of a new reference for every column.
Comments
-
I did a quick search to see if there was another feature request for the offset function, and I was surprised to find that there wasn't.
I think this is a great idea!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: β Auto Sorting β Sorting with Filters β Report PDF Generation β Copy and Paste Conditional Formats β Copy and Paste Automation Workflows β Column Manager β and so many more.
