Self Sheet Reference Drop Down

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

```

Find more posts tagged with

Accepted answers

All comments

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.