In Excel 2010, a simple and powerful feature was added to formulas used within tables: the @ prefix. All @Column1 means is this row in Column 1. It greatly simplifies the reading of formulas, and I would wager that accross the entire spectrum of Smartsheet users, most formulas are referring to cells within their own row. This makes the readability of formuals much better. Additionally, we have had problems when we move rows around in our most complex sheet, which has a nuber of complex formulas, some of which are over 200 characters in length. In addition to the complex formulas, the sheet is over 1300 rows and is 30 columns deep, and we're approaching the technical limits of the application. This is in part due to the massive amounts of row reference updates needed to be made in our formulas. If the @ symbol were used instead of the row number, those references would not need to be updated at all, because our formulas only refer to cell data for their own row.
In short, [Column1]@ in row 385 makes more sense to me than [Column1]385, and seems more scalable and user-friendly.
Of course, I'm making major assumptions in terms of technical complexity to implement this, but I thought it was worth sharing to the Community. I have already submitted this to techinical support as an enhancement request, but I wanted others Community members to have the opportunity to consider this request, and possibly submit it as an ehancement as well if it seemed like it would be beneficial.
Thanks!
