Is there a way to reference a row offset from @row in a column formula?
I'm setting a date range, and the end date will be the day before the next row's start date. I'd prefer to do it with a column formula, but there doesn't seem to be a way to get to "@[row+1]". Am I missing something? I frequently have applications where I'm referencing either the row before or the row after, and using column formulas would be preferable to remembering to fill down.
Best Answer

The short answer is that, no, you cannot reference rows relative to the current row in a column formula. You can get around this by adding a helper column that matches the row number. You can also use information in an already present column in some situations, for example... when working with dates, you can sometimes refer the latest date prior to the current row to reference the previous row. In my opinion, this is a weak point of Smartsheet, but usually there is a workaround.
If you have a specific sheet that is giving you trouble, feel free to post a screenshot.
Answers

The short answer is that, no, you cannot reference rows relative to the current row in a column formula. You can get around this by adding a helper column that matches the row number. You can also use information in an already present column in some situations, for example... when working with dates, you can sometimes refer the latest date prior to the current row to reference the previous row. In my opinion, this is a weak point of Smartsheet, but usually there is a workaround.
If you have a specific sheet that is giving you trouble, feel free to post a screenshot.

Thanks. That's what I figured and already completed what I was working on without a column formula. Since I do this fairly often, I wanted to know, if there was a way, and to otherwise provide more visibility on the lack. I think @nextrow and @prevrow would suffice most of the time, but I certainly wouldn't complain if @[row+x] (with positive or negative x supported) being an option. :)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 386 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!