Referencing rows

It is possible to reference a cell in a specific row, via a formula?

For example, I can say [Date]@row to get the date on the current row, or [Date]3 to get the date on row 3.

But I want the '3' to be a formula, which might be something like [Date]@([Reference]@row), where the value of [Reference]@row is 3.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!