Archived 2017 Posts

Archived 2017 Posts

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

Greetings:

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. 

 

Thanks,

AEG 

Comments

  • ✭✭✭✭✭✭

    Not specifically pointers, but ...

    sometimes I can get similar effects using LOOKUP, INDEX, MATCH, COUNT, and probably some others that escape me at the moment.

    I'd need to see the data (not a written description of it) to see what you are really trying to accomplish. I have not found a one-size-fits-all solution to referencing elsewhere in a sheet or other sheets.

    Craig

     

This discussion has been closed.

Trending Posts