How to create a Child Row, if the Parent Low is Linked

I am rather new to SmartSheets.....

If I DataMesh or Cell Link Parent Name from a different Sheet - it won't let me create child rows below it.

Ideally I want the Child Row to Select from a Drop Down Menu and for naming consistency I want the Parent row to be linked from another sheet. However it won't let me create Child Rows if I link the Parent row. Am I doing something wrong?

Find more posts tagged with

Accepted answers

All comments

vjschmid

Basically, I need a drop down in the Primary Column, which doesn't seem possible?

Is there a work around? For naming consistency, I need them to be able to select from a list....

Genevieve P.

Hi @vjschmid

You're correct - the Primary Column can only be set to Text/Number and cannot contain a dropdown list (see: Work With the Primary Column: Overview and Best Practices)

However you should be able to create a cell-link in a Parent row and still create Child Rows below. For example, you can see that I brought in "Test 1" through a cell-link:

Screen Shot 2022-03-03 at 1.04.11 PM.png

Keep in mind that in order to indent a row, that row has to contain some sort of content. You won't be able to make a blank row a child row. (See: Hierarchy: Indent or Outdent Rows)

If you'd like help setting up your sheet, it would be useful to see screen captures of what you're looking to do, but please block out sensitive data.

Thanks!

Genevieve

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.