Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Using pointers for relative addressing
Is this possible in smartsheet? (I have searched through the list of functions, a video on the use of cells, and the community but have not located any info on this.)
Would like a formula to look at the current row's dependency and treat that value as a pointer to reference the value on another column in the row represented by the value of the dependency; if you are familiar with pointers in "C" I think you will get what I am looking for (https://users.cs.cf.ac.uk/Dave.Marshall/C/node10.html).
Example: A sheet has the column [Unique ID], a Dependency column, and various other columns. One column would have a formula to look at the current row's dependency and use that value to reference the value in the [Unique ID] column in the row specified by the value in the dependency of the "current" row.