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.

Find more posts tagged with

BTW, Index won't work as this creates a circular reference.

Logging separate data points of the same type of data for one row
Looking for a way to easily log and reference multiple data points for the same type of data (ex: successful phone contacts) that all show for one entry (by member name). Want this to be both easy to enter the information (ideally by interacting with the same row via Dynamic View), and easy to see data on the back end of…
Help With If Count If to Identify Unique Values in a Column
I'm trying to make a helper column to identify if a new/unique project code has been entered in a column so that I know when a new project has been created. I've been trying to set up this formula and plan to then set up an automation to be notified when "New Project Code" has been entered into a cell. It seems to be ok on…
Create Formula at Grouping level
Hi, I have a source (and detailed) Smartsheet page with a lot of "detailed" transactions/rows. I created a report where I'd like to group the data and get some subtotals at the same time. If you check the picture (my new report), I'd like to group by "Task Name" , sum the "Hours", return the max of the "Estimated duration"…