Display only relevant for the forms

Hi All,

I am using forms for my timesheet data, I have multiple teams, I would like to have, when a team lead selects his team he should see only his team member list not others, how can I achieve this.

example: I have dropdown for 2 teams A and B, Team A has users 1 2 3 4 and Team B has users 5 6 7 8.

so when i Select Team A, I should only see users 1 2 3 and 4

Is this possible ?

thanks in Advance

Find more posts tagged with

Accepted answers

Paul Newcome

@heyjay Those dynamic dropdowns only work in the sheet level. It will not work to update dropdown options while filling out a form.

All comments

AjS

@heyjay, any thoughts ?

Paul Newcome

You would need to create separate dropdown columns for each team and use conditional logic in the form to show the appropriate dropdown. Either that or use a 3rd party form platform and integrate it with Smartsheet.

heyjay

Looks like you want a Dynamic Dropdown.

The logic I can see on forms is only limited to fields and not the dropdown.

Paul Newcome

@heyjay Those dynamic dropdowns only work in the sheet level. It will not work to update dropdown options while filling out a form.

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.