Conditional List Box

[balrammahato204]

Hi All,

Please help on below requirement.

I have one list box which is available on all sheets of the dashboard and this list box having the default selection value and can select the multiple values from this list box and able to filter the data. Now i want,  once movement is happen from one sheet to another sheet then only default selection should available on my list box and rest of the selection should be clear.

Please advise.

Thanks in Advance

Balram

[balrammahato204]

Please help on below requirement.

I have one list box which is available on all sheets of the dashboard and this list box having the default selection value and can select the multiple values from this list box and able to filter the data. Now i want,  once movement is happen from one sheet to another sheet then only default selection should available on my list box and rest of the selection should be clear.

Please advise.

Thanks in Advance

Balram

[Nicole-Smith]

You can set triggers on each sheet to reset the selections.

On each sheet:

1. Go to Settings > Sheet Properties
2. On the "Triggers" tab, you want to add actions "OnActivateSheet"
3.  Add "Clear Field"
   1. Enter the name of the field you want to clear
4. Add "Select in Field"
   1. Enter the name of the field you want to select in
   2. Enter the "default" value you want selected

[balrammahato204 · Accepted solution]

Thanks Nicole, 

Its Working 

Regards

Balram

---

@Nicole-Smith wrote:

You can set triggers on each sheet to reset the selections.

On each sheet:

1. Go to Settings > Sheet Properties
2. On the "Triggers" tab, you want to add actions "OnActivateSheet"
3.  Add "Clear Field"
   1. Enter the name of the field you want to clear
4. Add "Select in Field"
   1. Enter the name of the field you want to select in
   2. Enter the "default" value you want selected

---