Self Sheet Reference Drop Down

Options
Neal Lewis
edited 12/11/20 in Smartsheet Basics

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

```

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    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>

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Neal Lewis
    edited 12/13/20
    Options

    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?