Display only relevant for the forms

AjS

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

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.

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.