Self Sheet Reference Drop Down

Neal Lewis

Hello,

I have one autoincrement column: RowID

I would like to have another columns, InputRowIDs that can only be filled in by existing ROWIDs, and I would like these to be placed in a Drop down menu.

Is this possible? The output table would look like the table below. Everything in InputRowIDs should come from a dropdown menu

Example

```

PK :: RowID | InputRowIDs

0. :::: 0 | NULL

1. :::: 1 | 0

2 :::: 2. | 0

3 :::: 3 | 1, 2

4 :::: 4. | 3

```

Bassam Khalil

Hi @Neal Lewis 

Hope you are fine, maybe i can solve it for you in deferent approach if you like by creating automated calculation for new InputRowIDs if your target is not to have duplicated numbers. if this will help please prepare an excel file show what you need exactly and send it to my Email :

"Bassam Khalil - Mobil Project" <bassam.k@mobilproject.it>

Neal Lewis

HI Bassam,

thank you for you response. My target is to have a cell which reference one or more previous rows in the same sheet and can be updated at run time. Is this possible?