Clear - Always One Selected values in MultiBox

[vikasmahajan]

Hi,

I have multibox with Always one selected values in one sheet , actually when we clear all then it is not clearing in another sheet I want to clear it in another sheet , how to achieve the same.

Thanks

Vikas

[avinashelite]

if you have have a check on the Always single select value then it will not get clear ....

one alternative would be to un check the single select and use triggers to select a value in the same

[tresesco · Accepted solution]

In one sheet one value selected and in another you want clear all (nothing selected) - if this is what you want, you have to use Alternate State. Explore it.

[Anonymous]

Agreed with Avinash, Once you select this option Always one Selected Value, it will never clear.

If you want that on Clear All, it should get clear, then use sheet level trigger for same

[Kushal_Chawda]

For this need to use Triggers on Active sheet.

1) Select Values (In current sheet)

2) Clear Field trigger (On another sheet)

[vikasmahajan]

Thanks for all reply

Vikas

[Anonymous]

If you have got your answer, close the thread by selecting correct answer

[avinashelite]

please mark the correct and helpful answers and close this thread

[vikasmahajan]

Do you have simple demo for alternate state ?

[tresesco]

check here: About Alternate state.