Define Predecessors with Something Other than Row Number
Is there a way / formula that could be used to define a predecessor based on a value in another column, rather than having to look up the row number?
For example, each row in my sheet has a unique ID, and I want to be able to say the row(s) that match a certain list of ID numbers are predecessors to the row I'm in.
Help Article Resources
Check out the Formula Handbook template!