i have list box Flag here I need one more option like ALL
Result should be like
May be this
=If(GetSelectedCount(Button) = 0, 'Green Flag',
If(SubStringCount(Concat(DISTINCT '|' & Button & '|', ','), '|All|') = 1, '("Green Flag"|"Red Flag"|"Yellow Flag")',
'(' & Concat(DISTINCT Chr(34) & Button & ' Flag' & Chr(34), '|') & ')'))
when i select clear
flag list box want to select Green flag and button also want to select green
if i select green and yellow means it's not reflect in list box
So right now when you select clear, Green Flag is selected, but when you select Green and Yellow together, then nothing is selected? Is that the issue?
What do you want to see when Clear is selected?
What do you want to see when Green and Yellow are selected together?
by default or using clear--> Green want to select in button and listbox
other than that whatever user select in button it want to reflect in listbox
if they select all means it want to select all flag