Self Sheet Reference Drop Down

Neal Lewis
edited 12/11/20 in Smartsheet Basics


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



PK :: RowID | InputRowIDs

0. :::: 0 | NULL

1. :::: 1 | 0

2 :::: 2. | 0

3 :::: 3 | 1, 2

4 :::: 4. | 3



  • Bassam Khalil
    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" <>

    PMP Certified

    ☑️ 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

    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?