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
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!