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.
Absolute record references
Is there a convenient way to assign a fixed reference to a record that remains the same even if new rows are added or deleted anywhere above the record? Something like linking cells from another sheet, only within the same sheet, may work, too.
I often want to refer to another record, but if the record number changes as the project progresses, the reference becomes invalid. For example, at record 5 I may want to add the comment, "See row 20." If a row is added anywhere above row 20, it automatically renumbers to 21 (or 19 if a row is deleted). I do not want to link them as parent/child or predecessors.