Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I have one value always selected in the list box.
In the below tables, when I make any selection in the Region, I want APAC to be selected along with my selections. Similarly when I make any selection, in Market Sector, I should have the FI selected along with the selections I want. When I don't select anything from the Region or Market Sector, then it should not select anything. Thanks for the help.
Region |
---|
North America |
APAC |
EMEA |
LATAM |
Market Sector |
---|
FI |
ABC |
SF |
Copr |
Ok So it is based on Region.Solution provided by sunindia should work
You need this action:
='(' & Chr(34) &'APAC' & Chr(34) & '|' & If(GetSelectedCount(Region) >0, Concat(Chr(34) & Region & Chr(34), '|') & ')', ')')
Perfect. Thanks so much Sunny.